Viewing 15 posts - 36,991 through 37,005 (of 39,818 total)
You can use dbcc checkident to reset the identity. This could have happened.
To fix things, find the max value and ensure the identity seed is set here. Then you can...
October 31, 2002 at 11:34 am
Windows Auth won't transit most firewalls if they are setup securely. Windows Auth requires the NetBIOS ports.
Either use SQLAuth or setup a VPN like tunnel from your DMZ to the...
October 31, 2002 at 11:31 am
A good solution. I do something similar. I can snag the servername from the local server in some pacakges.
Not so smooth in SQL 7, but works great in sQL 2000
Steve...
October 31, 2002 at 11:25 am
You cannot create a parameter from multiple parts in the stored procedure call. You have to build it ahead of time. Architectural limitation.
Steve Jones
October 30, 2002 at 5:30 pm
Also, are you restoring over an existing db or a new db?
Steve Jones
October 30, 2002 at 5:21 pm
Check the physical sqlsrv.exe version in the file system.
Updated another server that had been updated with MS02-45 and had no issues. Show .679 as the version. Will do more servers...
October 30, 2002 at 12:07 pm
no.
change is made by user.
change recorded in log file (in memory).
change recorded in data file in memory
change recorded to log file on disk. May be checkpoint, may occur if system...
October 29, 2002 at 9:26 pm
You make a change. This is written to memory (buffer). On checkpoint, if it has not been written to disk, it now is. The normal, write log, write disk 2nd...
October 29, 2002 at 2:32 pm
You have an OS link. Go into Control Panel|Server or My Computers|Manage, depending on OS and look for open files. This should give you the login.
Steve Jones
October 29, 2002 at 10:16 am
Isn't this login or security error?
Perhaps you are expecting something to be created or loaded that happens when the rest of the steps run?
Steve Jones
October 29, 2002 at 10:14 am
I'd use a different join
from DataNortel dn
inner join DataLucent dl
on dl.ecp = 2
and dl.sid=4376
...
October 29, 2002 at 10:12 am
Or chr(13). I use Allen's suggestion. If you need the normal DOS end of line, use mine.
Steve Jones
October 29, 2002 at 10:08 am
Viewing 15 posts - 36,991 through 37,005 (of 39,818 total)