Got errors when I posted this and now it's there three times! And it won't let me delete it, either.

I think Jack meant to say SQL Server Configuration Manager (SSCM) instead of Surface Area Configuration. It is important that you change service accounts here and not in the...

One irritating word that's spilled out from IT into the wider world is solution. Ready meals are now meal solutions, and stereos are now home entertainment solutions. I...

Here's another couple of reasons why backup/restore may be better than detach/attach:

(1) You cannot always detach the database. This may occur if, for instance, the database participates in replication.

(2)...

What nobody's mentioned so far is that non-natural keys (ie identity columns) create uniqueness, but they don't enforce it. So if your table is CustomerStateID IDENTITY PRIMARY KEY, CustomerID,...

Thanks Bob - very close! You're right, it would be interesting to vary the tests in the way you suggest, and also to try out other mathematical functions that...

Bob

Are you sure about this? I've done some testing:

SET STATISTICS TIME ON

SET NOCOUNT ON

SET STATISTICS...

Judy

From the link you posted:

[font="Tahoma"]Locking pages in memory is not required on 64-bit operating systems.[/font]

You shouldn't need to use AWE in a 64-bit environment.

John

Edit: I've reread your post and...

Not as far as I know, since, according to Books Online, this counter measures the "Total number of times the transaction log for the database has been expanded". I...

Pierrick

You can use the dtsrun utility to run your DTS package.

John

vijaysingh (3/4/2009)

I can help you to find the particular word which are used in sp's

select p.name,m.definition from sys.sql_modules m

Inner join sys.procedures p on p.object_id=m.object_id

where m.definition LIKE '%User%'--Pass the word...

If you really want to do this then I think the only way is to put the work in and create an "audit" or "history" table for each "primary" table,...

It's better to use sys.sql_modules instead of syscomments, since, with the latter, there's the danger that the text you are searching for will be split between rows if your object...

1. Yes. You should assume that any kind of attack is possible and secure your systems accordingly.

2. Not necessarily. Again, assume the worst, and read up...

Here's a way of doing it in T-SQL. Obviously it won't work if the SQL Server service itself isn't running!

EXEC master.dbo.xp_servicecontrol 'QUERYSTATE', 'SQLAgent'

John