Hi, I have setup a linked server connection to a 2000 server ("MyRemoteServer") from a 2005 server. The link is working, I can for example make select statements. However when I execute a stored procedure on the 2005 server which in turn calls a stored procedure on the "MyRemoteServer" server...more >>

Hello: Here is the situation: There is a table (FILELOCATION) with two columns, one has an ID (integer) and another one is called FILES (string). BTW, these are not my creation! The FILES column contain location of various files. Examples are as follows: ID Files --- ----------...more >>

Hi, How can I display date in format m/d/yyyy. I searched BOL but could not findy any aurgument for CONVERT or CAST function to deal with. TIA Kay ...more >>

I keep getting the following error : Server: Msg 137, Level 15, State 1, Line 6 Must declare the variable '@MaxCourses'. For the following: DECLARE @MaxCourses int DECLARE @sql nvarchar (4000) DECLARE @ParamList nvarchar(4000) DECLARE @SL nvarchar(50) DECLARE @Dir nvarchar(50)...more >>

Need to purge a certain table every 24hrs But there are some requirements I need to purge the table of data that is 24hrs old starting at 10pm we are capturing timestamp on record insert, so if a record still exists in this table when we run the purge, if it is 10pm or 24hrs before then i...more >>

I have a Stored Procedure that has a column that sometimes has a value of NULL. When NULL, I would like to give the resulting column a value of "Other". For this I am using the ISNULL function which gives the desired result (meaning my NULL column has a real value). Possible values for thi...more >>

Hello: Here is the situation: There is a table (FILELOCATION) with two columns, one has an ID (integer) and another one is called FILES (string). BTW, these are not my creation! The FILES column contain location of various files. Examples are as follows: C:\WINDOWS\Help\AGT0406.HLP C...more >>

I read in help that the text datatype is going away. Does anyone know what will replace it? Or do you know where there is an article that may describe an alertnative? Thanks. ...more >>

Hello, I have a SQL 2000 table with several hundred thousands records. These records have several varchar columns (which are good and don't need to update) and some integer columns that have some records with null values in there. I would like to convert all those null values from the inte...more >>

i'm trying to define this: (see Below) which does work ok, except it will not accept the OPTION (MAXRECURSION 0). The Function will compile(run) with out the option, bu it will only goto a max of 100 levels before erroring out. How can i get the recursion level up to unlimited? with dates ...more >>

Hi all, Using SQL 2000 sp4 I'm basically archiving old data, so I'm copying over data I want to keep into another table with some new indexes. Looking for the fastest way to do this? Coping within the same database(Full mode) 100 million row table, from one table to another. Step...more >>

If you use a RETURN command in the middle of a transaction, does SQL rollback that tran or does it leave it open? Thanks in advance, Offeral...more >>

Can you call a stored procedure from a select statement? I already have a stored procedure "GetCurrentCharges" that is a stored procedure that passes back various pieces of data (Rate,PricePerUser,TotalCharge and CurrentCharges for example) and would like to be able to do something like: ...more >>

What comparison can I make so that I know that string "AD" is greater than string "AC" and less than string "AZ", but it's less than both string "CA" and "ZA"? Thnks. ...more >>

Hi, We are in need of setting up Audit Trail for one of our apps- About 60 tables, each table 620 columns. Our group seems to be spilt about using triggers vs. SP for this. My question is, is there a performance advantage to the master table (Table being audited) if we do this in a SP r...more >>

How can I change the password of the "sa" account in SQL 2005 Standard edition? ...more >>

I'm able to connect using DTS and a PG ODBC driver but is there a way I can connect to Postgres using some ODBC or OLE DB commands directly in Query Analyzer so I can run a Select statement? I can't seem to find any examples. Thanks ! ...more >>

Which one is better in SQL Server? Thanks ...more >>

I’ve got a 2000 database with FULL logging and log backups occurring about every 15 minutes. If you look at the log file using View/Taskpad, I see that this database has about 160M used and 9G free in its log file. Of course, I realize you should leave your logs with ample space so you ...more >>

Hi, I'm using ADO 2.8 to connect to SQLserver2000. I'm trying to understand that when I open a connection to it, I can use EnterpriseManager and it shows up to 3 connections. I know I created one. Is this normal? pooling? So how can I tell when I release the connection that it is actually rem...more >>

Hi All, Any body know of a foolproof way to identify indexes that have been created on a very narrow range of values, that probably would not be required for example: A column representing 'HasRecievedRegistrationEmail' 0 / 1 - two values are only possible. In some systems I have seen ...more >>

Does sql server have a way to handle errors in a sproc which would allow one to insert rows, ignoring rows which would create a duplicate key violation? I know if one loops one can handle the error on a row by row basis. But is there a way to skip the loop and do it as a bulk insert? It's ea...more >>

Hi, I have read lots of articles of how to write chunked to a TEXT field in SQL server but I cannot find any useful info on how to do it with SQL Server 2005 and the new varbinary(max). Can someone help me? Maybe even with some sample code? What I want to do is... a) write a stream to a va...more >>

Hi. I have a SELECT storedproc named spGetUnit which returns a single scalar value. I'm trying to create a separate SELECT stored which executes spGetUnit within it's SELECT command. Here is how I have it- Select E.EmpName,E.Salary,Unit=exec [spGetUnit] @EmployeeID=E.EmpName FROM Employ...more >>

My DB Server has been Creased and I don't have any backup plz don't ask why?, I recover the mdf and ldf files from the OS but when I am doing to attached the files so getting the error ... The header for file 'E:\data\mssql\data\ems_Data.mdf' is not a valid database file header. The PageAud...more >>

When rebuilding the master database,if the server had a particular service pack. I assume I would have to reapply this service pack as the master database will have lost all this information. As part of this rebuild I will not be restoring any of the system databases as none of these wer...more >>

I am trying to script the following - enable SQL authentification - assign “sa” password - add login (including password) - add user - assign user role (db_owner) - assign user password could somebody assist please tia Terry Holland...more >>

declare @ValueDate smalldatetime set @ValueDate = '21/05/2007' select @ValueDate error: The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value. Please note, if '05/21/2007' is used then there is no error. How is it possible to get 'dd/...more >>

Hi, I often have to start the same adhoc query against a few servers. The "change connection" feature which connects my current query to a different server could become handy, since I can select the new server with a click, some mousewheeling and one more click. But: although I have instructe...more >>