You can use the DNS name of the computer (mySQL.Mydomain.com) or it's IP address (10.1.1.1).

(local) is only when logged into the SQL Server computer, this is a built-in alias for the...

Search for "text and image functions" in books online (BOL):

SET TEXTSIZE, UPDATETEXT, WRITETEXT, DATALENGTH, PATINDEX, READTEXT, and TEXTPTR

Examples

This example reads the second through twenty-sixth characters of the...

Try searching for Pivot, there are many examples, choose the one that fits your situation like:

http://www.sqlservercentral.com/scripts/contributions/204.asp

or

http://www.sqlservercentral.com/scripts/contributions/506.asp

Andy

Looks like you have a space in the SQL Login name: ID=Theresa Kadlubowski

Try: ID=[Theresa Kadlubowski]

Or recreate the Login without a space, see rules for identifiers in SQL Server books online...

My guess is that you want to use NORECOVERY instead of STANDBY for the database restore, then NORECOVERY for each differential restore, then STANDBY for the log restores.

I do not...

You state "backup file" however your backup statement is for a "backup device" otherwise you would use the TO FILE, not just TO in your backup statement.

So I am...

Add PRINT @sql to see the resulting string, I'll bet it has to do with the parameters @GenericColumn or @GenericValue.

Andy

If you must use a non standard date format, then:

declare @date datetime

set @date = '16/Aug/2004 1:05:00 PM'

select convert(varchar,CAST(REPLACE(@date,'/',' ') AS datetime), 112) AS ISO

select convert(varchar,CAST(REPLACE(@date,'/',' ') AS datetime), 120)...

John,

Thanks for responding. I understand the legacy situation for the mssearch.exe, sorry for calling it Index Server. Glad to hear that this security hole has been addressed in SQL05.

Yes the...

John,

Do you have a clue why the Scheduled Tasks application uses the SYSTEM account to login to SQL Server when it runs a task?

I found this after deleting the...

Great work Jan,

I had some issues with the T-SQL so changed the function a little:

CREATE FUNCTION fn_IncString (@String varchar(6))

        RETURNS varchar(6)

AS

BEGIN

        DECLARE @C smallint,@Return varchar(6)

        SELECT @C=ASCII(RIGHT(@String,1))

        IF @C=90

                SELECT...

ANSI is :

CREATE TABLE Tables (TableName varchar(128), Rows int)

EXEC sp_MSforeachtable 'EXEC (''INSERT INTO Tables (TableName,Rows) SELECT TableName = ''''?'''', Rows = COUNT(*) FROM ?'')'

SELECT * FROM Tables

DROP TABLE Tables

Andy

By definition a CSV file has the comma Column delimiter and the CRLF (CHAR(13)+CHAR(10)) Row delimiter. Using anything else makes it no longer a CSV file.

Anyway the DTS Export to...

Try:

SELECT newPostSR.postid,newPostSR.subject,newPostSR.nam 

        , newPostSR.replies,newPostSR.views,newPostSR.dt

        , ISNULL(ReplySR.ReplyID,'-') AS ReplyID

        , ISNULL(ReplySR.Name,'-') AS r_name

        , ISNULL(ReplySR.dt,'-') AS r_date

FROM newPostSR

        LEFT JOIN (SELECT R.PostID,R.ReplyID,R.Name,R.dt

                FROM ReplySR AS R

                        LEFT JOIN (SELECT PostID,...

Why create a flat file table that will be very hard to maintain? Here is a better design alternative

CREATE TABLE #Pics (ImageID int identity, ID varchar(10)

        , Picture varchar(256), Thumbnail...