Viewing 15 posts - 21,421 through 21,435 (of 39,961 total)
Grant Fritchey (12/21/2009)
We've had several try to schedule deployments for the 24th. They seem shocked when we suggest that people might not be around on that day.
My worst deployment support...
December 21, 2009 at 9:00 am
users and roles are in your database anyway. As Pradeep mentioned, the logins are in master, so you are good if you restore that.
If you restore the database elsewhere, but...
December 20, 2009 at 6:09 pm
Did you create new logins when you restored the database on the new server and make sure those are mapped to users in the database?
December 20, 2009 at 6:04 pm
Jeff has a great link there, but what's your job? What are you supposed to be doing with SQL 2005?
December 20, 2009 at 5:54 pm
A couple hints,
use reverse, then charindex to find the "\" and then substring.
December 19, 2009 at 2:52 pm
Yes you can sync up and you'll want SQL Server Compact Edition.
there's a sync framework to check out: http://msdn.microsoft.com/en-us/sync/default.aspx
and compact edition is here: http://www.microsoft.com/Sqlserver/2005/en/us/compact.aspx
December 19, 2009 at 12:54 pm
there are lots of scripts in the Script section on this site that can help you.
you want to reuild typically not on when they were last rebuilt, but either on...
December 19, 2009 at 12:52 pm
Safeco is cool. Kalen Delaney took me there a couple years ago, and we saw the roof close in the midde of an inning. The Arizona park is cool as...
December 18, 2009 at 5:00 pm
We will. I'm not sure if they changed something else as they knocked off early today in the UK (Xmas party). Sending was definitely slower, so things might have been...
December 18, 2009 at 4:57 pm
These only work if UDP 1434 is open between servers. Lots of routers shut this down after the SQL Slammer worm.
The only way I know of for sure to find...
December 18, 2009 at 4:56 pm
In addition to Jack's ideas, you could go virtual if there isn't a large load on the system. Named instances as well, if you have the memory to support them.
December 18, 2009 at 4:52 pm
We went to Android, isn't everyone?
Patience, my padawans. I'm looking to write things up, but honestly I'm not 100% sure what the final was since I only had an opinion...
December 18, 2009 at 2:18 pm
You can backup and restore all SQL Server database, including master and msdb. That being said, only one SQL Server with that name can exist, so you'd have to change...
December 18, 2009 at 2:14 pm
I paid $300 for my netbook, and just got my son a laptop for $429 that's miles further. A laptop is a better deal most of the time for presenting....
December 18, 2009 at 1:41 pm
Viewing 15 posts - 21,421 through 21,435 (of 39,961 total)