Viewing 15 posts - 34,471 through 34,485 (of 39,793 total)
If 2 is cast as a datetime, isn't it converting a null to 1-1-1900 then adding 2 to it? The explanation says:
The null value in SQL Server is converted to...
November 4, 2004 at 9:25 am
The explanation wasn't worded greatly and has been corrected. Also, the ordering can't be known, but it's assumed, at least by me, that the "second row" referred to the NULL...
November 3, 2004 at 10:04 am
I think you need to delete this file and initialize a new one for SQL Server backups.
November 3, 2004 at 9:55 am
No good one I've seen. Maybe mail the owner of this site: http://www.vba-programmer.com/RefDocs.htm
November 3, 2004 at 9:51 am
No,
hopefully in 2k5, but no way to do this now. I've administratively (through email/memo) set a policy and then used NGS Software' SQLCrack to look for passwords that don't meet...
November 3, 2004 at 9:50 am
This can and does occur. I think it might have been fixed in a SP so it's not the default, but it does happen. It might not happen on YOUR...
November 2, 2004 at 10:41 am
Store the user and pwd in a table. Pass them to a stored procedure and return a 1 or 0, true or false, approved, failed, whatever.
November 2, 2004 at 10:37 am
No easy way to do this in SQL that I know of. You can return these in rows and then compute the number of distincts. Create a temp table using...
November 2, 2004 at 10:26 am
Third vote here. Detach dbs, use sp_help_revlogin (from MS) to script logins. Save of DTS packages, uninstall, reinstall.
November 2, 2004 at 10:24 am
You're welcome. Sorry I couldn't get more detailed, but since it's Beta, I'm sure MS doesn't want to publish too much.
November 1, 2004 at 10:14 am
You can script it out and run the script on the other server or try the Copy Objects Task in DTS. Select only users, roles and permissions. The objects have...
October 31, 2004 at 9:24 am
Wow a complement. What do I do with those ![]()
October 29, 2004 at 1:53 pm
Is the remote server running on localsystem? I think I've had issues with this.
October 29, 2004 at 1:52 pm
don't forget to drop the old server with sp_dropserver
October 29, 2004 at 1:51 pm
Viewing 15 posts - 34,471 through 34,485 (of 39,793 total)