Viewing 15 posts - 34,546 through 34,560 (of 39,726 total)
There is no way to determine this after the fact. If you are getting deadlocks, use the hints above to setup a trace and look for them.
September 24, 2004 at 10:17 am
Rather than search for the city name, what about searching for the state and then adding the comma before it?
September 23, 2004 at 10:03 pm
Get the performance plan from Query Analyzer. CTRL-K should turn it on. Run your query and then look at the performance plan. It will clue you in to the sections...
September 23, 2004 at 10:00 pm
Be sure this SMS account has rights to connect to SqL Server. It logs in like any other user of SQL Server.
September 22, 2004 at 10:04 am
See the other thread: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=138256
September 22, 2004 at 9:49 am
You might try the compare tools from Red Gate and Apex SQL to see if they handle this.
September 21, 2004 at 11:06 am
I believe the autoval column in syscolumns has a value for identity coluymns.
September 21, 2004 at 11:05 am
Escape it by doubling them up.
select * from table1 where name like '%''%'
September 20, 2004 at 4:07 pm
The user might own things that the role wouldn't.
September 20, 2004 at 12:06 pm
There isn't a way to limit by user, only by total connections.
September 20, 2004 at 12:01 pm
That is strange. Under what account does the DTS package run? Is is a sysadmin? Is your DB owned by sa? Does this happen if you run them interactively instead...
September 20, 2004 at 12:00 pm
I'm not sure what you mean by shares. As far as logins, search sp_help_revlogin on MSDN and you can use that script to move logins for SQL 7 and 2000.
September 20, 2004 at 11:59 am
Nice complement and indeed I get lots of questions submitted, well not lots, but probably 1 of 10 is submitted. However, most people don't want to get credit because of...
September 20, 2004 at 11:58 am
I'm not sure what you mean? You can go back and answer the old questions.
We're also getting a book ready with previous questions of the day for sale. Look for...
September 20, 2004 at 10:02 am
Thanks, and since I'm posting, it worked, sort of ![]()
September 20, 2004 at 10:00 am
Viewing 15 posts - 34,546 through 34,560 (of 39,726 total)