Viewing 15 posts - 38,581 through 38,595 (of 39,754 total)
Keep in mind that I do not think this will handle indentity conflicts. If you allow updates to the subscriber and it takes an identity value already in use in...
January 22, 2002 at 9:48 am
Yes, you would select isnull( column_name, '') replacing column_name iwth the appropriate column. Replace '' with whatever value you want returned ('NULL', 0, etc.).
Steve Jones
January 22, 2002 at 9:35 am
Try running setup on the original SQL Server. It has options for rebuilding master, reinstalling, change network support, and code page. You should get the existing setttings from there.
Steve Jones
January 22, 2002 at 9:32 am
I'm surprised attaching the database without the log file did not work. Try using the EM GUI and specifying the data file for a new database, but renaming or deleting...
January 22, 2002 at 9:21 am
January 21, 2002 at 5:04 pm
January 21, 2002 at 4:58 pm
January 21, 2002 at 4:55 pm
I've used BackupExec and liked it, but it only really allowed me to grab multiple servers easily and manage the schedule.
I have a friend who swears by NTBackup and uses...
January 21, 2002 at 4:53 pm
I've done a few restores at IBM's location and we install the servers and then restore from the backup file. This has worked well and in the event of a...
January 21, 2002 at 4:51 pm
January 21, 2002 at 4:42 pm
Interesting. Did the users get setup in some special way to cause this? What was the settting?
Steve Jones
January 21, 2002 at 4:40 pm
I think this is fixed for v6.5 servers and not changeable by db.
I know SQL Setup will show this.
Steve Jones
January 21, 2002 at 4:24 pm
January 21, 2002 at 2:06 pm
run netstat -a from the server through VNC. Verify you have a listener on 1433.
hmmm, strange. Server set to SQL auth and you are using SQL auth. Not a...
January 21, 2002 at 1:34 pm
Is there a firewall or router between you and the box?
Do wht Brian said:
1. Ping ip address
2. check your client config
3. Check server network config
4. Be sure SQL is running
5....
January 21, 2002 at 12:56 pm
Viewing 15 posts - 38,581 through 38,595 (of 39,754 total)