Viewing 15 posts - 841 through 855 (of 972 total)
It is helpful if you can include some sample data.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
January 6, 2010 at 6:30 am
Krasavita (1/5/2010)
The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space..
How can I fix...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
January 6, 2010 at 6:25 am
In agreement with Jeffrey, use the tools that came with the version of SQL Server 2000. If the you don't have access from your desktop they would be accessible...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
January 5, 2010 at 9:11 pm
david.ostrander (1/5/2010)
I'm trying to create a new backup job for a sql server 2000 db in Sql Server Management Studio 2008. I keep getting error messages that point...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
January 5, 2010 at 4:04 pm
Krasavita (1/5/2010)
The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space..
How can I fix...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
January 5, 2010 at 3:53 pm
In agreement with John.
What do you see in the other Windows event logs that correspond to the time frame of the stop messages? The events showing within Windows Event...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
January 4, 2010 at 8:48 am
ducon (1/4/2010)
Hi there,I would love to find a book dedicated to the query optimizer that explains how it works, how it chooses certain plans over others etc.
Greg
ISQL Server Execution Plans[/url]
It...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
January 4, 2010 at 8:41 am
I like SSMS pretty well. Seeing a log viewer as a separate app would be great, quick and easy to check the logs. Something that would be nice...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
December 9, 2009 at 8:06 am
kevinsql7 (12/2/2009)
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
December 2, 2009 at 1:41 pm
This link has a good video along with it from Brent Ozar that goes through restoring a multiple file database. Sorry it is not an exact script for you...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
November 4, 2009 at 10:55 am
I believe you would need to have a pound sign (#) in front of your table name to create it as a temporary table.
So you would reference it like:
IF EXISTS...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
October 28, 2009 at 2:29 pm
Thanks for the assistance!
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
October 20, 2009 at 9:18 am
Just curious but with the size of data you are keeping how will you keep the database under 4GB, which is the database size limit for SQL Server Express?
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
October 15, 2009 at 8:14 pm
Well State 11 seems to show it is a valid login but does not have the proper access to log into the server.
If you take the group login on the...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
October 15, 2009 at 5:45 am
sunshine-587009 (10/14/2009)
Error:Cannot connect to SErvaname\INstance.
------------------------------
ADDITIONAL INFORMATION:
Login failed for user 'xxx\xxx. (Microsoft SQL Server, Error: 18456)
Any help appreciated!
You may have already read this post, but there should be an entry after...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
October 14, 2009 at 12:14 pm
Viewing 15 posts - 841 through 855 (of 972 total)