Viewing 15 posts - 3,526 through 3,540 (of 7,191 total)
As for the requirement to find row size....
If all your columns have fixed-width data types such as int, datetime and char(100), just divide the table size by the row count...
June 11, 2014 at 8:03 am
ashalatha.cse76 (6/11/2014)
while deleting the cat_id from category table if i want to get a message then how to do regarding cat_id is present in order table
Under what exact circumstances do...
June 11, 2014 at 7:50 am
A good place to start is to look at the 6th June backup. What size was that? Assuming your database hasn't had any significant growth between then and...
June 11, 2014 at 7:45 am
As Gail said, monitor for a week. If you can't wait, query msdb.dbo.backupset to find out what the sizes of your log backups have been. Make sure you...
June 11, 2014 at 7:31 am
I don't know of any way to INSERT from a stored procedure that returns multiple result sets. Is it an option to rewrite the stored procedure?
John
June 10, 2014 at 9:02 am
Greg
The CASE expression returns a result with the highest precedence data type of the all the result expressions. I'm not sure how you get round that.
John
June 10, 2014 at 8:48 am
It's not about the permissions you have. You need to make sure that the SQL Server service account has read permission on the backup location in order to do...
June 10, 2014 at 5:34 am
vijay.singh 14112 (6/10/2014)
Please find the error message below.
Msg 3169, Level 16, State 1, Line 1
The database was backed up on a server running version 8.00.0760. That version is incompatible...
June 10, 2014 at 2:04 am
Could it be a firewall or routing thing? Presumably when you run it from BIDS, you're doing it from your PC, whereas with SQL Server Agent, it runs from...
June 9, 2014 at 8:55 am
Because you can roll back a DROP DATABASE, but not a RESTORE.
John
June 9, 2014 at 8:43 am
Don't bother with the trigger. Grant the user CREATE ANY DATABASE, but make sure he/she/it is not (a) the owner of any database you don't want overwritten, (b) a...
June 9, 2014 at 8:32 am
Probably because in BIDS, it runs in your security context, whereas in the job, it runs in the context of the SQL Server Agent service account. Have you checked...
June 9, 2014 at 8:10 am
Vijay
I'm sorry, I misread your question. I thought you were asking about upgrading the server. You should be able to restore a 2000 database on 2012. What...
June 9, 2014 at 4:39 am
Vijay
There's no direct upgrade path from 2000 to 2012 - you have to go via 2005 or 2008. You don't have to go through them both, though.
John
June 9, 2014 at 2:41 am
Is the SQL Server VSS Writer service running? I think that makes backups at times that can appear arbitrary.
John
June 6, 2014 at 6:01 am
Viewing 15 posts - 3,526 through 3,540 (of 7,191 total)