Viewing 15 posts - 38,296 through 38,310 (of 39,456 total)
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
I've tried to do this, but haven't figured it out. If you move to a uniqueidentifier, then you can do merge replication and things will work.
Steve Jones
January 21, 2002 at 12:20 pm
I agree. Or jsut pass in the items you want to split from the deleted table as parameters.
Steve Jones
January 21, 2002 at 12:14 pm
Not sure here either and I'm not sure the multi-protocol will easily pass a firewall.
I'd agree that SSL and public certificates might be your best bet.
Steve Jones
January 21, 2002 at 12:04 pm
January 21, 2002 at 12:01 pm
Brian is right. Once you have a server that is a domain controller, it no longer has a "local" SAM. Therefore there is no local administrator.
Steve Jones
January 21, 2002 at 11:59 am
there is no extension required in SQL Server. In EM, you can select the file restore and "pick" the file. If it does not show up, you can manually specify...
January 21, 2002 at 11:57 am
Interesting. I tried this awhile back, but couldn't get it to work and bailed. I can take a look tomorrow.
Steve Jones
January 21, 2002 at 11:18 am
January 21, 2002 at 11:10 am
January 21, 2002 at 10:16 am
Not sure if you can reliably get this, but I'd try some of the suggestions above. Let us know!
Steve Jones
January 21, 2002 at 10:13 am
Viewing 15 posts - 38,296 through 38,310 (of 39,456 total)