Viewing 15 posts - 376 through 390 (of 610 total)
I do this with most of my backups. The first step of the sql agent job does the backup then if success goes to a next step which is set...
November 9, 2009 at 6:04 am
I can get this in SQLServer 2005 (with various different servers) if I go to a job in my Management Studio (version 9.00.4035.00), right click and select properties and click...
November 9, 2009 at 5:49 am
Set the delay validation property to true to stop it checking the connection file before the variable is properly loaded. I can't remember if it's on the connection manager or...
October 23, 2009 at 7:25 am
I did that this morning by copying the formula exactly from one cell's background expression property to the other! It wasn't worth the effort of trying to do something clever....
October 23, 2009 at 7:20 am
keep the sales people away from the databases. They're the last people on earth who should have 'sa' privs.
Agreed. Very heartily. Especially when it's ACT by Sage which has so...
October 21, 2009 at 3:53 am
Are you sure about the name as all my sharepoint servers default install as Servername\Sharepoint for the instance name? I'd put INSTANCENAME=DevBox\Sharepoint for example.
October 20, 2009 at 4:40 am
Yes I've done this with a script source in the dataflow which uses the system.directoryservices facilities.
Code below:
Change your server, domain, DC, login and password of course. Add other properties as...
October 20, 2009 at 4:30 am
I've had something similar where I needed to allow time for an action to complete - once it was an external batch file run and another time a stored procedure....
October 20, 2009 at 4:19 am
You will need to create a proxy - read up on Proxy and Credentials in Books Online or google it.
October 20, 2009 at 4:11 am
There are quirks with Excel, particularly that the Excel data source takes the data type of the columns from the first eight rows so if you have a text column...
October 19, 2009 at 4:57 am
If you just want to straightforward copy of the tables try the Import Export wizard from management studio. Right click the source database, select Tasks, then Export data and follow...
October 19, 2009 at 4:45 am
When you run under the agent the package is being run by the agent login. When you run from the IDE or management studio it's from your login. Hence you...
October 19, 2009 at 4:34 am
It isn't the badly phrased, minimal information questions which make me see red but the posters who, given a line of research or something to try, just say "Just give...
October 15, 2009 at 4:41 am
I have found variables in scripts to be case sensitive too so ensure you use exactly the same each time.
October 13, 2009 at 1:16 am
Viewing 15 posts - 376 through 390 (of 610 total)