Forum Replies Created
Viewing 15 posts - 39,031 through 39,045 (of 39,720 total)
-
RE: SQL Server Worm Virus
As far as I know, there is not name yet. Not sure if there will be a patch since you would have to scan all connections to SQL Server and...
-
RE: What Is Syncobj ???
Is this a user database? Which version of SQL? How are you getting the information that where are 3000 views? Did you create 900 views in this db?
Some more...
-
RE: Creating a simple insert to text trigger.
Use >> if you do it through a shell.
select @text = ColumnA from TableA
exec master..xp_cmdshell 'echo ' + @text + ' >> c:\test.txt'
Steve Jones
-
RE: DBO vs. as owner
Do you mean new objects, or existing objects?
Existing ones will have to be changeed with sp_changeobjectowner
Steve Jones
-
RE: DBO vs. as owner
Should workin both. Are you getting an error? Perhaps he still has a login in the db.
Steve Jones
-
RE: Table w/ large number of columns
Slow ass DMO coders!
BTW, as to the original question, do you ahve other tables that return quickly? Perhaps you are IO constrained.
Steve Jones
-
RE: Worst Practices - Depending on the GUI
I'll give it a try, but I'm not sure a GUI is necessary. As a design tool, I'd agree, but for making changes, I think I'll stick with my scripts.
Steve...
-
RE: Point in time recovery (EM)
probably beginner's luck
. I'm sure it works, but if it fails, you are stuck holding pieces and may end up manually doing it instead. I like... -
RE: Creating a simple insert to text trigger.
This is dangerous to do in a trigger. The insert will not complete until the write does and that could be an issue from the OS.
From a trigger, you could...
-
RE: Deleting columns
Can you just post all the column names? or generate a script for the creation of the table.
Steve Jones
. I'm sure it works, but if it fails, you are stuck holding pieces and may end up manually doing it instead. I like...Viewing 15 posts - 39,031 through 39,045 (of 39,720 total)