Forum Replies Created
Viewing 15 posts - 1,801 through 1,815 (of 2,436 total)
-
RE: DBCC Showcontig
Why a linked server ? You can just execute it from QA ... am I missing someting here ?
-
RE: @@servername ????????? empty output
After executing sp_adderver ...,local you need toi stop/restart SQL Server.
Just a little 'undocumented feature' that's been around since v4.21 ...
-
RE: Server randomly slows performance.
Just curious ... what did MS say that each of the trace flags did ???
-
RE: MSDTC fail on Active\pasive cluster
Is the server presently in production (I'm guessing no at this time). If the server is not in production I'd opt for the simple solution on this one:
- Break the cluster
- Re-enable...
-
RE: Automating SQL Server Service Pack / Patch / Hot fix apply
First off automation is a no-no to many things can go wrong - the worst being that you have to recover (reinstall) a SQL Server. Second, having users assist in...
-
RE: Change of Domain on SQL Server machine
I'm not so sure the AD migration tool will 'fix' Windows logins/groups within SQL Server ... but who knows ... any word on getting 'technical person' ???
-
RE: Which SQL Server edition to buy?
Developer edition has no 'throttles' - it's basically Entetrprise Edition under the covers.
-
RE: How to make the db files smaller than orig. created?
Run DBCC SHRINKFILE , then the ALTER/MODIFY.
-
RE: Linked server security: ogin failed for user ''''sqllinked''''. Reason: Not associated with a trusted SQL Server connection
Are you using domain user accounts for the SQL Server Service and SQL Agent Service ? Are the accounts the sameon each server ? Are the service accounts set up...
-
RE: Change of Domain on SQL Server machine
Yelana is on track with all of the changes (here's probably a few more lurking, dependent on which features you use). After the prep-wprk when removing the computer from the...
-
RE: SQL2000 from Windows 2000 sp4 to Windows 2004 sp1
I too have Win2K and Win2K3 servers in production and have performed this upgrade a number of times without issue. By default when you install SQL Server 'BUILTIN\Administrators' has sysadmin...
-
RE: Custom Job Manager Role
Thanks a ton Terry ! I'll let you know if I can change anything for the better !
-
RE: Active/Passive cluster
I'm guessing the "Virtual SQL Server Instance IP" ...
-
RE: How to add column in specific position
Chris, an ANSI 'flaw', I think not. Column order does not matter at all in the DDL. The 'flaw' is in the interpretation. Below I've excerpted a post of mine...
Viewing 15 posts - 1,801 through 1,815 (of 2,436 total)