Search results for query: *

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...

Ok thanks. But I have specifically read in places that it "invalidates the truncate log" but I guess it's more an issue of symantics. It never made sense to me that SQL Server would design a product in this way anyways, as if this were the case it would be a critical design problem.

Hi, I have a table where I reset the identity field upon inserting new data. I truncate the old data before inserting to accomplish this. However, I have read that using "truncate" invalidates the transaction log. I've never really figured out what this means and if it is a problem. That...

I'm sorry, this is TOO weird. And I'm not making this up. First of all, I ruled out schema issues by running the 2 queries above. Not that I thought this was the issue, because I don't use schemas. I even RENAMED the function to something unique in Database B. When I run my function: SELECT...

I'm not sure I understand what you're saying. The default schema for all databases is "dbo"

SELECT dbo.myFunction(GETDATE()) I can't figure this out. If I run the above statement in Database A, it works fine. But if try to run it from Database B on the same server, I get an error: Msg 4121, Level 16, State 1, Line 1 Cannot find either column "dbo" or the user-defined function or...