Viewing 15 posts - 76 through 90 (of 178 total)
I've compared by generating a create script on two agent jobs and using a text comparison tool (notepad++ I believe) to see the differences. That was enough for me...
May 11, 2009 at 6:18 am
So is this what you mean? Your file looks something like this:
Field1,Field2,Field3,Field4,Field5,Field6
1,2,3,4,5,6
6,5,4,3,2,1
And you want to pull it out something like this:
FIELD1 FIELD2 ...
May 8, 2009 at 11:25 am
If we take full back up daily, does it break the LSN chain?
full & diff do not break the chain. It will continue to work as long as you...
May 8, 2009 at 11:19 am
Well the network team should probably calculate the bandwidth. But for a QUICK ESTIMATE (you really need to test), take your network speed, subtract 20-30% for overhead and calculate...
May 5, 2009 at 7:49 am
If your primary is available during failover, then you would backup your TL with no recovery. Then you could apply TL backups from your secondary that you failed over....
May 5, 2009 at 7:21 am
Perhaps a trigger causing this?
May 4, 2009 at 11:34 am
This doesn't have enough details to get a response. I would suggest stating some more information
What tools do you use to import/how are they imported?
How many at a time...
May 4, 2009 at 11:18 am
are you talking about server event forwarding in sql agent?
set it up how you want in ssms on one of your non-configured servers, then (instead of hitting OK) press CTRL-SHIFT-N
it...
May 4, 2009 at 11:11 am
in this case I believe you'd have to setup a linked server and the proper local to remote login mappings.
May 4, 2009 at 11:06 am
You could create a .NET service in Visual studio that deals with it.
Set your dependent service to manual start
Create new Service that starts automatic
New service does something like this:
Connect to...
April 29, 2009 at 9:09 am
it looks to me you've setup an ODBC connection with SQL authentication, and you are trying to use a WINDOWS account to authenticate.
You need to either setup your ODBC as...
April 29, 2009 at 8:59 am
Run this:
EXECUTE master.dbo.xp_dirtree 'D:\Temp', 1, 1
Replace D:\Temp with the folder you copied your database files to. Do they come up?
April 20, 2009 at 10:45 am
I believe that would indicate the sid of one of the logins you are trying to transfer is already in use for an existing user on your destination server. ...
April 14, 2009 at 12:46 pm
if you go to control panel, add/remove programs, click change on Microsoft SQL Server, does SSRS show up as installed? If not, install it as new component and update...
April 14, 2009 at 8:04 am
You probably should start here:
http://technet.microsoft.com/en-us/library/ms345223(SQL.90).aspx
April 14, 2009 at 7:59 am
Viewing 15 posts - 76 through 90 (of 178 total)