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)

---

Hi,

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

Thanks, guys. I was really only interested in SQL Server permissions, so what Markus says sounds like what I need. Can anyone else confirm or deny it at...

Bear in mind also that the DMVs are cleared down not only when SQL Server restarts, but also when databases undergo certain changes of state, such as to or from...

That's another limitation of Andy's method from which mine doesn't suffer - you can't make updates directly to the system tables on SQL Server 2005.

John

Someguy (8/19/2008)

---

I do want to encourage you (and maybe a few others who wander through sites like this) to realize that your strongly held views are controversial; be careful of...