Viewing 15 posts - 34,906 through 34,920 (of 39,723 total)
They shouldn't be sa. Since I assume you will refresh QA fairly often, give the developers db_owner in the dev database, and when you refresh QA, have a script that...
May 19, 2004 at 10:38 am
There is no integration with EM. The only way I've been able to do this is remove rights from the dev server and designate someone to make changes. This way...
May 19, 2004 at 10:33 am
Not sure what you mean. What's "BIG" and "One Day"? Can you provide some actual dates with examples? I suspect you want to use a CASE statement, just not sure...
May 18, 2004 at 8:12 pm
I usually grab the sp completed, and stmt ending events, check the duration and do a count of the instances and go from there. I think the standard template that...
May 18, 2004 at 3:44 pm
glad I could help. When you see something strange like this with an index, constriant, etc. Often it's bound to another object.
May 18, 2004 at 3:43 pm
I believe developer edition is licensed differently. There isn't a per processor or client AFAIK. You cannot use this for production. You'd need to uninstall, then reinstall the server version...
May 18, 2004 at 3:41 pm
seemed to drop it fine when I did it on my local server. I expect that somehow the constraint got linked to a different table. Can you check in sysconstraints...
May 18, 2004 at 11:56 am
If there is an error in the first item, a rollback will occur and there is no transaction. You don't want to do the save if the first rollback occurred.
May 18, 2004 at 11:37 am
That's the only way I know and it only works for indexes or tables that have a clustered indexes. not sure how to determine for Stored procedures, heaps, views, etc.
May 18, 2004 at 11:35 am
I used a low tech approach.
http://www.sqlservercentral.com/columnists/sjones/vcspart1.asp
May 18, 2004 at 11:31 am
SQL Server will move through the log files and log to one, then the other, using virtual log files within each physical file. You need to add some transactions, truncate...
May 18, 2004 at 11:15 am
My process isn't without flaws and I'm sure I can learn a few things from you guys. It worked well and 90% of the time, so I just dealt with...
May 17, 2004 at 1:44 pm
Not that I know of, but I plan on doing some sp2 testing on a VM over the next few weeks. Will let you know how it goes.
May 14, 2004 at 9:36 am
How are you doing the insert? You cannot turn off logging, but you can BCP in with different logging or commit after xx rows to minimize the log growth.
May 14, 2004 at 9:32 am
You must be rebuilding indexes or doing something I don't do. None of mine fail when a conneciton is open. Some of the options require an exclusive connection in the...
May 13, 2004 at 10:18 am
Viewing 15 posts - 34,906 through 34,920 (of 39,723 total)