Viewing 15 posts - 3,061 through 3,075 (of 6,216 total)
Why not just detach msdb and move to the new server?
Andy
October 20, 2002 at 5:08 pm
You have to use dynamic sql, like this:
exec(sql) or sp_executesql (@sql)
Andy
October 19, 2002 at 11:01 am
Lots of options here. Using just NT authentication to control db access usually isnt good enough, it leaves open the possibility of someone connecting with something besides your app (MS...
October 19, 2002 at 11:00 am
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
October 19, 2002 at 12:00 am
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
October 19, 2002 at 12:00 am
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
October 19, 2002 at 12:00 am
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
October 19, 2002 at 12:00 am
Agree. We've got a couple places where we cache data and only want to pull it if changed, eventually built our own versioning scheme - basically we know that once...
October 18, 2002 at 5:06 pm
If you use a sql login and it fails, it'll try to use a trusted connection - well, in ADO world anyway! I'd double check how you're defining your connection.
Andy
October 18, 2002 at 5:04 pm
It'll work. Its just an object, you can make any changes to it you want (given you have permissions), then just save.
Andy
October 18, 2002 at 5:03 pm
October 18, 2002 at 5:03 pm
You'll have use FTP for the snapshot (or FTP a backup, restore on subscriber first), but after that all it should take is connectivity. VPN a better choice, more secure,...
October 18, 2002 at 5:02 pm
I think(!) that SQLZip uses a proprietary near zip format. Not a bad product, I've got a review posted if anyone wants to take a look. Brian Knight has also...
October 18, 2002 at 4:58 pm
declare @NewKey int
insert into table1(col) values (blah)
select @NewKey=@@Identity
If you're using SQL2K you should use the scope_identity() function instead.
Andy
October 18, 2002 at 5:42 am
For a simple table doing it from ADO/.Net would work. Work out what the command should be in Query Analzyer, then just do a connection.execute "create table..." in your app.
Andy
October 18, 2002 at 4:44 am
Viewing 15 posts - 3,061 through 3,075 (of 6,216 total)