Its on the general tab of the server properties dialog, just above autostart properties.

(Right click on the server name, and select properties)

Steve

Most likely the default collation of the AAD database differs from the server default.  The choices are to use the collate statement as you described, or change the collation of...

SQL dump is the same thing as a SQL Backup.  Back in the old days (SQL 6.5) the command was DUMP instead of backup.  A lot of people still call...

The only thing I see is that you don't have lengths defined for your parms.

Try this....

create procedure dynam_oper

(@operator char(2),

@value VARCHAR(3))

as

declare @sql nvarchar(4000)

set @sql = 'SELECT * FROM pubs.dbo.sales

                 WHERE qty...

Take a look at INFORMATION_SCHEMA.VIEW_COLUMN_USAGE in Books online.

Steve

Greg,

Take a look at this thread...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=162&messageid=146617 

Steve

Ok, this is at least slightly bizarre.  What are the chances that two guys named Steve post nearly identical questions within 40 minutes of eachother?  If I can ask to...

Naveen,

So glad we've been able to help!  I have to second Frank's comment that we are NOT here to cater to pros.  These forums are for SQL users of ALL...

Thank you, Frank.

Steve

Joe,

Perhaps you would have been happier if I had said, "Your data model really doesn't belong in a SQL table.  Perhaps you should consider a sequential file for what...

Naveen,

As Joe less than tactfully explained, SQL Server does not store data in the sequence in which you insert it, even when using an identity column.  Neither does it present...

Michael,

I KNEW that I had seen something that was very simple, yet ingenious for this.  But I couldn't find it!!  That's it!  Good job!

Steve

For the second time today, I have to give credit to Frank!  I knew that I had seen solutions to this problem on this site, just couldn't remember the solution.

Anyway,...

OH! OH! OH!  Just found this!!!! (Well, ok, I didn't find it, I found another thread that references it.  Thanks Frank!!!)

http://www.sqldts.com/default.aspx?105

Steve

A quick search on SQLServerCentral.com yielded the following article on transferring DTS packages -

http://www.sqlservercentral.com/columnists/awarren/copyingdtspackagestoadifferentserver.asp

There were also numerous threads in the forums that showed up in that search.

My search...