@terry: Yes, using a string parser may be a solution in this case. However I'd rather build such a tool in .NET (C# or VB NET) - since...

tosscrosby (3/19/2009)

---

Based on your sample data, wouldn't you use quote separated or am I missing something? Using the import wizard, I believe it's the first or second screen after you...

Since the question didn't mention any details about the isolation level, I assumed that it is the default READ COMMITTED...

If you query sys.dm_tran_locks you'll see an IX lock taken on the test_tran table.

If you run in the second window SELECT col1 FROM test_tran WHERE col1 = 1 (or...

What do you mean by "the fact that an object uses the login"?

Is the login member of the "sysadmin" server role?

Maybe an "or" instead of the "and" would be more appropriate...

See also http://msdn.microsoft.com/en-us/library/ms189612.aspx

You can start with reading the BOL section about bcp.

I think that SQL 2008 offers a feature (the resource governor) that's close to what you want, see

http://msdn.microsoft.com/en-us/library/bb895232.aspx

How can you tell in advance that your users will perform searches using only certain words? Am I missing something?

Jeff Moden (3/12/2009)

---

No... not for the application the OP is going to use and almost never for everything else because both methods are slow...

Is this true for...

Try also:

CONVERT(CHAR(8), GETDATE(), 114)

CONVERT(CHAR(8), GETDATE(), 108)

You can find some info here: http://msdn.microsoft.com/en-us/library/ms178028(SQL.90).aspx - however they are not listing the "default sizes". Try to monitor the system databases sizes after a fresh install.

If so, things are getting a little more complicated. See

http://msdn.microsoft.com/en-us/library/ms180800(SQL.90).aspx

As far as I know you'll need to grant permissions on the view.

As for the REFERENCES permission - it...