Viewing 15 posts - 316 through 330 (of 1,156 total)
Does the agent account have the appropriate rights? You should setup a proxy with the appropriate rights to run the package.
March 14, 2008 at 9:21 am
NP, let us know how it goes. 🙂
March 14, 2008 at 9:19 am
Just another thought, but it's worth mentioning. You could backup the
source database and restore as the target database and delete all the
data from the target database.
The script...
March 14, 2008 at 9:15 am
Debbie,
Piotr's example is exactly what you are looking for. In his example, you pass in 4 parameters into the main stored procedure,
@FolderDate datetime
@Servicea string
@acYearStart datetime
@Serviceb...
March 14, 2008 at 8:53 am
Go into you databases and script out some of your sProcs. Now look at the scripts. See, that is how the Scripter (and Microsoft) do it.
I second this....
March 14, 2008 at 8:20 am
Put in the SQL Server 2005 disk. The client tools are in the setup and are called workstation components. Install only the workstation components.
March 13, 2008 at 8:24 pm
It looks like Adam answered a different question than was asked.
You can install the CLIENT TOOLS (SQL Server Management Studio) on a desktop or the server.
You can only install the...
March 13, 2008 at 5:34 pm
There might be a single-update command for this, but I think it would be so incredibly complex, since it would have to determine how many zeroes there are for each...
March 13, 2008 at 4:12 pm
Can't seem to find any answer as to if the full version can be installed ONLY on the server. Seems like that's the case. Is it??
This depends on your licensing....
March 13, 2008 at 3:38 pm
Clustering is a high availability solution, not a disaster recovery solution. Clustering provides high availability because it automatically swings all the data to another server, in the event of...
March 13, 2008 at 12:03 pm
ForEachDB would simply this process for you 10 fold. As mentioned earlier, it does uses cursors, but is so dang convientent.
Your statement should look like this:
EXEC master..sp_MSForeachdb '
USE [?]
IF DB_ID(''?'')...
March 13, 2008 at 11:18 am
hi thanks for your script, does your script do the same thing create a table with all the metadata information from the system tables?
In summary, it is basing...
March 13, 2008 at 11:03 am
Nice script $sanjayattray 🙂
hi thanks for your script, does your script do the same thing create a table with all the metadata information from the system tables?
No, it is...
March 13, 2008 at 11:02 am
I may be a little late but these are some of the date/time functions, I have found over the years. I hope it helps.
DECLARE @Date AS DateTime
SET @Date =...
March 13, 2008 at 9:46 am
... or, you can just use the power of UNION...
What's funny is our code is exactly the same, minus the temp table. I was only thinking about inserting...
March 13, 2008 at 8:26 am
Viewing 15 posts - 316 through 330 (of 1,156 total)