Viewing 15 posts - 4,591 through 4,605 (of 7,429 total)
Which version of SQL are you using. If 7 then you will need help killing the virtual logs inside the TL.
See http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=26&CategoryNm=Maintenance%20and%20Management%20&CategoryID=1 for a great script to do this.
However I...
October 22, 2002 at 5:28 am
Or try opening a cmd prompt and CD to the directory that SQLGUI.DLL is in. Now type REGSVR32 SQLGUI.DLL -u to unregister and then REGSVR32 SQLGUI.DLL to reregister. This generally...
October 22, 2002 at 5:24 am
WHat type was this message, information, warning, or error? As for the first line this is generic when no valid event message package is defined in the application for this...
October 22, 2002 at 5:20 am
Try
USE DBANME
GO
Then your create
Or try CREATE TABLE dbname.dbo.tablename (....
and yes you need to specify at least one column within the CREATE TABLE statement, you can append others thru ALTER...
October 22, 2002 at 5:05 am
Specifically what are you trying to accomplish? Without knowing what the end result should be and how it should be reached I am not sure what answer you need.
"Don't roll...
October 22, 2002 at 5:02 am
There is another thread on this here somewhere. However it boils down to the hiring manager and the company.
Some places prefer certification, some require and some just don't care. It...
October 22, 2002 at 4:59 am
quote:
I usually look at the graphical representation of the execution plan available in Query Analyzer not only because I'm lazy but also...
October 22, 2002 at 4:36 am
Unfortunately, there is a lot to do if you watch EM to make sure constraints, key referneces, and permissions stay in place. So using EM look at the table and...
October 21, 2002 at 4:41 am
quote:
If I just set truncate on checkpoint Off
If you are saying that it is on...
October 21, 2002 at 4:30 am
No, you cannot customize EM in any way to prevent this. You can either write your own EM type application or use a third party app that is similar to...
October 21, 2002 at 4:23 am
As for backup and resotre and sp_detach_db and sp_attach_db SQL 7 to 2000. System databases master, model, msdb and distribution (if you have replciation) are not intended to be transfered...
October 21, 2002 at 4:20 am
You cannot seperate tables to seperate files within the same filegroup. To migrate them to seperate files they must be set to seperate filegroups. This does not affect the database...
October 21, 2002 at 4:12 am
Unfortunately there is nothing that states o many bytes were delivered and no replication profile that can help get this. The only thing yo have available is performance monitor to...
October 21, 2002 at 4:08 am
That is a very good thread, the only thing is are you comparing to Oracle or some other platform (Informix, Sybase, MySQL, etc.). As fr advantages and disadvantages there is...
October 21, 2002 at 3:55 am
abhi there is not. I have 6.x, 7 and 2000 (of course 6.x was very generic help file and not very usefull so I have a copy of the actuall...
October 21, 2002 at 3:47 am
Viewing 15 posts - 4,591 through 4,605 (of 7,429 total)