Recent content by thamms

thanks

Hi, Why doesn't this work: CREATE PROCEDURE myProc @JobName NVARCHAR(400) AS BEGIN EXEC sp_add_job @job_name = @JobName, --@JobName is a parameter @delete_level = 0 END Error message: Cannot add rows to sysdepends for the current object because it depends on the missing object...

Help What is the t-sql syntax to drop a job? Thanks

I figured it out: @command = ' + 'N'''+ '' + @SPName + ' ' + @Params + ''''

Thanks... Now I am having this problem. Here's my code: alter PROCEDURE [dbo].[CreateAndRunDynamicJob] (@JobName NVARCHAR(400), @DBName NVARCHAR(400), @SPName NVARCHAR(400), @Params NVARCHAR(400)) AS BEGIN DECLARE @SQL NVARCHAR(400) SET @SQL = 'sp_add_job @job_name = ' + @JobName EXECUTE...

Help, I can't get this to work: declare @JobName nvarchar(100) SET @JobName = 'XXX' sp_add_jobstep @job_name = @JobName, @step_name = N'Run job step', @subsystem = N'TSQL', @command = N'EXEC Staging.dbo.test' Error: Msg 102, Level 15, State 1, Line 3 Incorrect syntax near...

I wanted to add something to my original post. If you are installing the 64 bit version of SQL Server 2005 standard edition from downloaded files, you definitely need both CD's, not just CD1. I ran into myriad problems under the previous assumption of only needing one disk, even though CD2 only...

Hi, If I install the msdn version of SQL Server 2005 on a development machine, is it possible to later upgrade the license to "standard" edition, when the machine is changed to a production server? How easy/hard is this to do? Thanks

Thanks. Is there a way to specify a separate location for the system db data and log files? That is, putting the log files in their own location?

Hi Mr. Denny, What should the minimum permissions be if all I want to do is run xp_cmdshell? That's what I'm having trouble determining. Thanks

Hi, I need to set up a proxy account to allow users to run xp_cmdshell on a linked server. My question is, is there a preferred window account to use for the proxy? Thanks

Hi, Let's say you have Database "Joe", that has 10 users mapped to it. Now, let's say you have Database "Fred" on another server, and you want to set up the same 10 "Joe" users in "Fred," with the same exact permissions as they have on "Joe." Is there a simple way to do this without having to...

Hi, I just did an installation, and I want to get a reality check. Q1.) I downloaded SQL Server 2005 (x86) from the developer website as ISO files. There were 2 files: CD 1 and CD 2. I mounted the ISO files so I could read the contents. I ran setup.exe from CD 1. The installation only...

The identity field is just used to determine which row (in a staging table) is next to another for our programmer's purposes; the rows change every day anyways, there's no fixed data to begin with.

Hi, I have a non-admin user that I would like to grant "sp_start_job" permissions to. I ran this statement successfully: grant execute on sp_start_job to myNonAdminUser However, when I log in as this user, and attempt to start a job, it says that the "@job_name does not exist" The job does...