Forum Replies Created
Viewing 5 posts - 1 through 5 (of 5 total)
-
RE: SQL ODBC Connection running slow
could be DNS lookup issues on the machine using the 3rd party app...?
-
RE: CHANGING THE IP ADDRESS
changing the ip should be no problem
these are the bits that need doing in sql to reflex a machine name change
-
RE: Ho can i truncate transaction Log?
You can also truncate the log without performing a backup by setting the recovery model for the database to simple and use dbcc shinkdatabase (can also use shinkfile)
stick something like...
-
RE: SQL Server email notifications for the operator
if you got a smtp gateway that could reply smtp messages you cound use an extended stored procedure using xpsmtp80.dll
search on the web for the dll and your'll find more info
we tend...
-
RE: Changing Object Ownership
i use the following stored procedure I found ages agoexec chObjOwner 'test','dbo''output code to using sp_changeobjectownerViewing 5 posts - 1 through 5 (of 5 total)