Answer Questions

• kangalert Running SQL JOB for SQL Express >>>>>

  I need to run a SQL script as a job for SQL Express. How can I do this Are there any programs that will allow me to do this I do not understand why Microsoft went through the trouble of removing the Sql Agent scheduler from SQL 2005 Express. This is wrong for any product path/roadmap. There are many small applications, both in-house IT as well as distributed, that depend on the reliable SQL Server Agent Job scheduler. I stopped using the Windows Task Scheduler years ago because you cannot count on it. It is not reliable. While it has improved since the NT4 and early Win2000 days, it is only marginally better due to a UI instead of the AT command line. We need the service, SQLSERVERAGENT, to b ...Show All

• HKEC Configuration of Reporting Services

  obviously until I get this sorted I cannot deploy my reports in my Reporting Services Configuration All ticked except initialisation (3) in Database services ticked but on the right hand side there are warnings/errors Verifying Database Edition - ticked Verifying Database Version - warning The current connection string is not valid and can't be used to connect to SQL Server Where do I check this (1) Creating A Grant Rights script for LocalSystem = ticked Assigning Reporting Services Rights to User = error (2) System.Data.SqlClient.SqlException: The role 'RSExecRole' does not exist in the current database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at Syste ...Show All

• leclerc9 SQL Memory Usage - Sudden Raise in Usage

  Hi, We were performing Stress test for our .NET application that uses SQL Server as Database. We could see a steep increase (about 1GB) in usage of memory by SQL server when we monitor Available MBytes through perfmon. The Available MBytes is reduced from 15300 to 13500 in 15 mts. I feel it is because SQLServer adds memory to its buffer pool, but not really using it for any process. Still I'm not sure about this. The questions that I have after looking this perfmon value 1. What causes this steep increase in memory usage 2. If the memory is allocated to Buffer Pool, how do we control this and how to justify that the memory is allocated only to buffer pool 3. Why does SQL Server doesn't release memory from Buffer Pool once the s ...Show All

• ThisSummer Export/import Maintance Tasks

  Hello, is there any way to export/import maintance tasks from one SQL Server to another We have two SQL Server with same DB. Every day launch a couple of maintance tasks for DB to stay in good state. It will be very helpful to make possible to export/import maintance tasks. I see that maintance tasks are SSIS packages stores in SQL Server. But don't know how to export it. Any suggestion Thanks Anton Kalcik Thanks Open SQL Server Management Studio Select File and then Connect Object Explorer Change the Server Type to Integration Services, connect to the server Expand to Servername (Integration Services) | Stored Packages | MSDB | Ma ...Show All

• liujj_xujj Real World: Backup Strategy and implementation, how?

  Real World: Backup Strategy and implementation, how A quote: “Real World: Whether you back up to tape or disk drive, you should use the tape rotation technique. Create multiple sets, and then write to these sets on a rotating basis. With a disk drive, for example, you could create these back files on different network drives and use them as follows: //servername/data1drive/backups/AWorks_Set1.bak. Used in week 1, 3, 5 and so on for full and differential backups. //servername/data2drive/backups/AWorks_Set2.bak. Used in week 2, 4, 6 and so on for full and differential backups. //servername/data3drive/backups/AWorks_Set3.bak. Used in the first week of the month for full and differential backups. //ser ...Show All

• bes7252 Trying to get jpg image saved to sqlce db

  I'm trying to get this logic to work in vb.net.  I keep getting errors on assigning the value of the image to the parameter.  Also, how do you do the reverse and retrieve it from the sqlce db into a picturebox   Any help is greatly appreciated.  Thank you. Dim value As ImageFormat Dim imageBytes As Byte () Dim cn As SqlCeConnection Dim strSQL As String Dim cmd As SqlCeCommand value = ImageFormat.Jpeg Dim ms As New MemoryStream() pbxPhoto.Image.Save(ms, ImageFormat.Jpeg) imageBytes = ms.ToArray() cn = GetConnectionStart(cstrSQLCeFileName) strSQL = "UPDATE BaltPhoneDir Set Photo = Values ( ) LName_1 LIKE '" & strLastName & "' AND FName_1 LIK ...Show All

• Jamie Thomson Return empty rows for not existing data - possible?

  Can you help me solve this problem, please. The main table t0 seems not to be relevant here but contains all the unique information to an article. Each article can have many ingedients and several other 1:n related things. The one I have difficulties right now is t1 (analyse). Each article can have entries for 0 to 15 types of analyses that are stored in t2. Now I need a web entry form that lists all types of analyses with either the existing values or empty fields. It's no problem for me (althouh not very nice) to store empty values on save but I need to show the form even for new articles or existing artices that have no entries yet for analyse. I tried something like this: SELECT t1.id, t1.analyseid, t1.analysetyp, ...Show All

• MatthewVincent HELP !! HELP: Trigger to send REPORT !!!

  Hi all, Report Manager is failing to email out the reports !!! And... I can not use Report Manager to configure the trigger ! How can I trigger manually to have SQL 2005 email out the reports again OR how can I trigger to run those emailing jobs again Thanks, Frank Ok... let's say I want to use SQL Server Agent to run the job that can trigger the Report Manager to email out reports, do you guys have any documents that can show me how to do so I checked and ran some jobs under the SQL Server Agent, I don't see anyone of the jobs that were created to email out the reports, if there were no jobs created to do such task, how did those subscriptions email out before ...Show All

• fchapa Cannot connect to SQLExpress

  Hi, I'm using Microsoft SQL Sever Management Studio Express. But all of a sudden, if I clicked connect button, the messageBox pops up and it doesn't let me connect. It says "TITLE: Connect to Server ------------------------------ Cannot connect to YOUR-4105E587B6\SQLEXPRESS. ------------------------------ ADDITIONAL INFORMATION: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1) For help, click: http://go.microsoft.com/fwlink ProdName ...Show All

• Esqueleto An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue

  Hi Guys, Can anyone help me with this error An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Protocol error in TDS stream". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Protocol error in TDS stream". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Protocol error in TDS stream". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Communication link failure". An OLE DB record is available. Source ...Show All

• Jason D. Camp Return bottom 10 rows not working.

  Ok so this is more then likely very easy for most. But for me it's hard. I have a stored proc that I've been able to get to retun just the top 10 rows and have been able to order it asending. But it will only return the top 10 and I need to bottom 10 of the selection. set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER proc [dbo] . [proj_ListFiles] ( @project_id int ) as select top 10 ( @project_id ) id , project_id , filename , contenttype , length from proj_file where project_id = @project_id How can I make it return to bottom 10. On a side note about this, when it returns the recordset they all have the 'id' of the 'project_id' that I selected. Not that the side note really bothers me as it will no ...Show All

• helsingfors XML Problem when scheduling SSIS package

  I am getting an error when I try to schedule a package. I can run the package with no problems from BIDS. For some reason it is throwing an error when I try to schedule the package using SQL Server Agent. Information on how to resove this would be greatly appreciated. Executed as user: MACHINE\SYSTEM. ...n 9.00.1399.06 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 5:41:55 PM Error: 2007-02-19 17:41:56.01 Code: 0xC0011007 Source: {48427B5A-10F6-4054-B7EB-F0F19B90F334} Description: Unable to load the package as XML because of package does not have a valid XML format. A specific XML parser error will be posted. End Error Error: 2007-02-19 17:41:56.01 Code: 0xC0011002 Source: {48427B5A-10F6-4054 ...Show All

• krhoover Integrated Security

  Hi, I tried to access sql server through windows authentication with the latest 6/26 JDBC driver. My url is "jdbc:sqlserver://<hostname>:1433;integratedSecurity=true;". I was getting error "Invalid integratedSecurity property value:true". Can someone know how to resolve it Thanks. run sql profiler trace. have a look of whats happening at the server perspective. verify if there is really an activity in the server JDBC driver does not support integrated authentication yet. There is effort to ship it in next release. Stay tuned. Thanks, Thanks. I ran sql profiler trace, and there are activity on that server and inst ...Show All

• ruleDWorld Oracle to SQL Server Migration using Server Migration Assistant for Oracle V2.0 - Help Needed

  Hi all, I am basically a front end guy and we need to do a dB migration from Oracle 9i to SQL Server (sitting in a shared environment). For the start we wanna try out this tool. This tool provided by the MSN comes along with an extension pack that needs to be installed along with the tool. http://www.microsoft.com/downloads/details.aspx FamilyId=E35CEE88-C919-463F-B020-81468CD231DA&displaylang=en It’s mentioned there that Server component installation: Locate a SQL Server machine which you want to migrate to. Run SSMAExtPack.exe on that machine locally.It will install a sysdb database with procedure and functions that emulate some of the Oracle system packages. You don't need to d ...Show All

• Javahar Check if there is trigger

  Hi, How can I check if there is trigger for one table, and if yes disable if ( there is trigger in cm_template = yes ) ALTER TABLE cm_template DISABLE TRIGGER TRG_cm_template else do stuff... Since I try disable one trigger in a table which there is not trigger I think I'll receive one error. am I right cheers, If you are using 2005, this is really easy: select object_name(parent_id) as table_name, name as trigger_name, is_disabled from sys.triggers For 2000, you can use: SELECT OBJECT_NAME (parent_obj), name, OBJECTPROPERTY (id, 'ExecIsTriggerDisabled') as is_disabled FROM sysobjects WHERE type = 'TR' Credit: By Srinivas Sampath MCSE, MVP (SQL Server) in his article: h ...Show All