Viewing 15 posts - 36,481 through 36,495 (of 39,771 total)
SQL Server doesn't support arrays. You could simulate this with a table datatype or temp table or perhaps a cursor.
For a tree, there are multiple ways. Is this a tree...
March 19, 2003 at 10:37 pm
There are some utilities, like checkident and set identity_insert, that are not designed to allow anyone to use them. The reason is likely that often the developer's have not thought...
March 19, 2003 at 8:44 pm
Tend to use what's installed only. EM, QA, Profiler, Perfmon.
recently moved to Litespeed for backups.
Steve Jones
March 19, 2003 at 8:40 pm
The date is stored internally in SQL Server in its own format. The client display depends on what is set on the client system.
If you want to convert it you...
March 19, 2003 at 8:38 pm
Nothing. Permissions for this default to the object owner, dbowner, and sysadmin.
Steve Jones
March 19, 2003 at 8:35 pm
I thought th restricton was 4GB.
If you enable AWE, you should be able to go to 4GB
Steve Jones
March 19, 2003 at 8:33 pm
I'd worry that something popped up a dialog. Can you send other mail? Maybe the outlook startup is looking for a profile?
If it won't kill, then you probably need to...
March 19, 2003 at 9:39 am
Do not set IDENTITY INSERT ON and don't insert anything for the recordid.
Steve Jones
March 18, 2003 at 10:11 am
This is actually pretty simple. SQL Server stores it's name in master.dbo.sysservers using the entry that is set as local to respond to (in addition to localhost and (local) ).
connect...
March 18, 2003 at 10:09 am
If you selectively turn off some queries, then you start to lose the benefits of query plan caching. I would think that you would want to build separate queries and...
March 18, 2003 at 10:00 am
March 17, 2003 at 11:06 pm
Write a procedure to disconnect people when the sysprocesses.lastbatch is over 15 minutes.
Schedule this to run every xx minutes.
Steve Jones
March 17, 2003 at 3:27 pm
Haven't seen that one. I'd guess you may need to call MS on this one.
Steve Jones
March 17, 2003 at 10:01 am
I'm guessing that it isn't completing correctly. Does the stored procedure work and complete if you run it in query analyzer?
Steve Jones
March 17, 2003 at 9:37 am
That's the simplest method (above) with a cursor.
Steve Jones
March 13, 2003 at 9:40 am
Viewing 15 posts - 36,481 through 36,495 (of 39,771 total)