Viewing 15 posts - 1,906 through 1,920 (of 6,216 total)
I restore frequently on the same server with different name, haven't had problems. Is the db accessible at least?
Andy
July 16, 2003 at 4:12 pm
Please keep your comments professional. Disagreeing is fine. Being disrespectful is not. Thanks.
Andy
July 16, 2003 at 3:11 am
All you have to is change your connection string to use NT authentication. No reason to worry with a sql login/password. Downside is that you're authorized db access to NT...
July 15, 2003 at 3:32 pm
If you're going to do it very often you'd want to run it as job and save the results, it'll be slow connecting to x servers until you find the...
July 15, 2003 at 3:08 pm
Are you looking for a pure TSQL solution, or would code work too?
Andy
July 14, 2003 at 3:47 pm
July 14, 2003 at 1:20 pm
Replication will work as long as you have connectivity. If you know when you'll have a connection, you could schedule the job to run then. Otherwise you either have run...
July 14, 2003 at 1:17 pm
Shouldnt need anything. You can have someone check the switch, see if you're having problems there. Is performance on the SAN ok otherwise? At some point you're going to max...
July 14, 2003 at 11:27 am
Using an approle from Access is just like any other app, you call the proc (setapprole?) and then you're authorized. But that works to let people in, not keep people...
July 14, 2003 at 11:24 am
I run the distributor on the publisher and pay very little attention to it over what I normally monitor. Replication is very stable, only problem I see with any frequency...
July 14, 2003 at 8:41 am
Or sp_executesql, which has the advantage of reusing query plans.
Andy
July 14, 2003 at 5:53 am
Run sp_change_users_login to fix. Unless you match the SID in sysxlogins match the original server you'll have to do this each time you do a restore on the other server.
Andy
July 14, 2003 at 5:52 am
We're counting distinct users - so it wouldnt hurt if you did click submit twice!
Andy
July 14, 2003 at 3:05 am
Sure the connection is open? Permissions set on the proc? Tried checking to see if you're getting a recordset back at all?
Andy
July 13, 2003 at 8:31 pm
That's the way! The key is the with move to change the file names on disk. It's probably the best way. Alternatives are to detach the db (which takes it...
July 13, 2003 at 9:20 am
Viewing 15 posts - 1,906 through 1,920 (of 6,216 total)