Viewing 15 posts - 1,516 through 1,530 (of 1,530 total)
use sp_helpfile to determine the filenames and locations of database and log files.
May be the tempdb is on your C:
or logfiles from your production database are kept on C:
To move...
December 12, 2008 at 10:17 am
refer to the following msdn link.
http://msdn.microsoft.com/en-us/library/aa337114(SQL.90).aspx
December 12, 2008 at 9:39 am
We do need this trigger to work recurisvely but obviously I don't have something in the trigger right. How can I determine what line it's stopping on?
This is happening at...
December 12, 2008 at 9:31 am
can u run this query and let us know the results..
select name, xtype from sysobjects where name='x_old'
December 12, 2008 at 1:02 am
The error message is self-explanatory. The new owner already has an object with the same name. in your case there is already an object x_old owned by dbo.
December 12, 2008 at 12:07 am
If your concern is to move the incremental data from your production server to the secondary server, you can setup log-shipping where all the changes are applied to the secondary...
December 11, 2008 at 11:57 pm
In Full Mode the log is backed up frequently which keeps its size down. Is this the only reason for doing frequent backups?
You take backup of the log files to...
December 11, 2008 at 10:56 am
My understanding was that in Full Recovery mode you should try and back up you log say every 30 minutes in case your log became corrupt
I guess u've not...
December 10, 2008 at 12:09 pm
To put your database in single user mode immediately, fire this.. Note that all incomplete transactions will be rolled back immediately.
ALTER DATABASE [yourDatabase]
SET SINGLE_USER WITH
ROLLBACK IMMEDIATE
If you wish to...
December 10, 2008 at 9:58 am
writing triggers on all tables would be little cumbersome and as said earlier would hit production.
You can also think of implementing log shipping. keep log backup interval relatively higher and...
December 5, 2008 at 10:42 am
If you're monitoring through enterprise manager, it does get into hung state when there is intensive IO activity.. you can see these activities and locks by querying syslocks and sysprocesses...
December 5, 2008 at 9:54 am
Thanks Jerry. My question gets answered in that link.
December 5, 2008 at 9:21 am
Also this statement looks confusing..
you're trying to update org_id in LOCATIONS table with uname ( i assume it's meant to store person's first name) from PERSON Table....
December 5, 2008 at 6:55 am
alter database DB_NAME set read_only
December 5, 2008 at 6:49 am
alter database set read_only
December 5, 2008 at 6:49 am
Viewing 15 posts - 1,516 through 1,530 (of 1,530 total)