Viewing 15 posts - 38,296 through 38,310 (of 39,466 total)
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
sp_foreach uses cursors. Cursors aren't necessarily bad, just inefficient. You can usually find other ways of doing things, but i use them all the time in administrative items.
Second, you can...
January 21, 2002 at 12:34 pm
you can just insert into table B using insert TableB select * from inserted which will capture multi-row inserts. Keep in mind that TableB should not have an identity.
Steve Jones
January 21, 2002 at 12:29 pm
This defeats the benefits of stored procedures. You'd be better off writing multiple stored procedures and calling the appropriate one. You can even write on main procedure that determines which...
January 21, 2002 at 12:23 pm
Viewing 15 posts - 38,296 through 38,310 (of 39,466 total)