Viewing 15 posts - 35,911 through 35,925 (of 39,903 total)
We'd love to have an article on this. Or a few!! drop a note to articles@sqlservercentral.com for guidelines and we'll get you going.
For now
http://www.sqlservercentral.com/forum/forum.asp?FORUM_ID=137&CAT_ID=1&Forum_Title=SQL+Server+CE
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server...
October 24, 2003 at 3:57 pm
What type of step? I think a non-zero exit code will do it.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 23, 2003 at 12:52 pm
No idea, but I'll try to look.
and thanks.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 23, 2003 at 12:50 pm
Check the script library here. You can delete from teh tables (not recommended). I believe that there are some things that are limited in history, i.e. maintenance plans and clean...
October 22, 2003 at 3:22 pm
I mean the main PSFT db. How large is that, how many users? Which modules?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 20, 2003 at 3:53 pm
Interesting. Can you set an alert and capture sp_lock when the deadlock occurs. Might help with determining the answer.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 20, 2003 at 10:54 am
How big is your PSFT db?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 20, 2003 at 10:53 am
It's a tough issue because you have to define "up". If the server is running, but someone can't connect to the server (network issue), is the database "up"?
I'd script something...
October 20, 2003 at 10:46 am
Nice summary of items. Personally I usually set parameters to NULL and then check for NULL to display the "you need parameter x" included" message.
I'm wary of external documentation. People...
October 20, 2003 at 10:44 am
Thanks
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 17, 2003 at 9:46 am
There isn't a way to do this after the fact. There is no "audit" of tables used or altered, only those that are created.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com...
October 17, 2003 at 9:45 am
This doesn't really make sense. Are there answers stored somewhere? What's with all the "testxxx" rows?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 17, 2003 at 9:44 am
Not sure about that. In a limited test, it appears I get the same execution plan either way.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 16, 2003 at 10:01 am
Apologies on v7. Not sure how many of them work, but QA was a 1.0 product in 7 and substantially enhanced in 2000.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002...
October 16, 2003 at 9:44 am
Daily - Backups!! Make sure these work
Weekly - Run dbccs, maint plan helps here. Patches, etc. We have a weekly window available for maint. Don't always take it, but dbccs...
October 16, 2003 at 9:41 am
Viewing 15 posts - 35,911 through 35,925 (of 39,903 total)