Viewing 15 posts - 841 through 855 (of 972 total)
It is helpful if you can include some sample data.
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...
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...
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...
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...
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...
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...
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...
December 9, 2009 at 8:06 am
kevinsql7 (12/2/2009)
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...
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...
October 28, 2009 at 2:29 pm
Thanks for the assistance!
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?
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...
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...
October 14, 2009 at 12:14 pm
Viewing 15 posts - 841 through 855 (of 972 total)