Search results for query: *

i have a stored proc that queries tables from several databases on different servers. Must I give read access to every table that this proc queries? is there no way to simply give execute to the proc and they can run it?

I am trying to figure out how to create a script task. I have some script I'd like to run, I just dont know how to make it work in ssis. does it go into activeX script task? what else do I have to do to get it ready for running it ?

I have only started researching ssis, but know stored procs pretty well. My question is, is there any reason to use a ssis project over a stored proc? as far as I can tell everything that can be done with ssis can be done more easily with a stored proc.

I've heard it is possible to embed vb script in a stored prod in sql server 2005. Is that true? If so How? (I like examples) :-p

We've been experiencing a strange error withe sql server 2000/2005. Usually happens if I leave my computer logged in over night. I'll be working in management studio running querys agains verious servers with no problem. I come in the next day and try to run the exact same queries and get...

I have a stored proc which checks a directory for files and sends out an email if any are there. I'm updating it to look at subfolders now as well, and would also like to change it so it only shows files older than 1 day. Everything is working except for the files contained in subfolders, I...

I have a stored proc that uses xp_cmdshell. I have a web interface that we would like to use to call this proc. You can see the problem. Can really just give the web user access to run xp_cmdshell. Anyone know a workaround for this that wont compromise the database?

I want to use a case statement to run varying commands, but even a simple case wont work unless i use "select case" but doing that wont let me run a command.

Anyone know how to use a display name for the from email when using xp_smtp_sendmail? The problem I'm running into is I have some records that contain somethign like "name" <email@domain.com> which apparently worked with whatever was being used previous to xp_smtp_sendmail, but it errors out...

what is the easiest way to migrate a dts to ssis? IS it possible to simply past the code into a script task? Keep in mind my vb and ssis experience is pretty limited (I'm working with a dts created by another coder)

I'm to prepair a dts writen using vb prackage for 2005 using ssis. Problem is, I have no clue. I've done a lot of work writing stored procs, but have no idea where to even start with ssis...not even sure how to get to it, is it a seperate program?

I'm creating a table dynamically and need to be able to use a case for the column length. if it is an int or date or whatever there is no column length, but if it's some other I need to include it in my statement. the table I'm using to create this table contains: column_name column_datatype...

I'm having problems trying to add indexes and constraints to a table in a linked server. This is what I currently have: SELECT @sql = 'ALTER TABLE ' + @v_listserver + '.[' + @v_listdatabase + '].dbo.' + @p_listname + 'ADD CONSTRAINT [PK_' + @p_listname + '] PRIMARY KEY CLUSTERED...

I found this site with a bunch of useful codes and was going over them to see how i might use them. This is the only one that I just could not figure out. Can someone explain what it's doing and how it might be useful to a dba? Before I kick this one off, please remember that these measures...

I need 1 record for each part. This record must have max(date) and max(identity#) and type must = "a" or "u". Example: ident# Part quantity type date 1 1234 460 a 3/12/2007 13:35 2 1234 10 u 3/13/2007 13:35 3 1234 50 1 3/14/2007 13:35 4 5421 46 a 3/14/2007...

I am writing a stored proc (proc1) that will need info from several tables. It just happens that this info is generated in an already existing stored proc (proc2). I tried using INSERT INTO #temp_table EXEC proc2 but recieved the error: An INSERT EXEC statement cannot be nested. How can I...

How is this done?

I found the bol help for this, but the first step stumps me :-p it says; 1. Right-click anywhere in the Connection Managers area, and then click New Flat File Connection. Where is the connection managers area?

I'm investigating using partitions in 2005 and need to know about compacting, using read only, best practices for managing large (200 mil rows) tables. I have set up a table with datetime partition in quarterly buckets. This table will have arround 10-20 million rows in each partition. each...

I have a table that is separated into filegourps by quarter and partitioned by quarter using insertion date. I want to run some tests on this table and the partitions so I need a way to query a specific partition. ie select * from table1.partition1 where dateinserted = getdate() (just an...