Search results for query: *

sql 2005 btw

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 ?

Ya, you are right, of course. Just getting frustrated. DTS was real easy for me to pick up because I had tons of examples already. So far trying to lean ssis has been pretty frustrating. Everyone says rtfm, but I've never been able to learn from manuals, so I'm sitting here spending forever...

Nothing specific that I'm trying to do. Just looking into ssis and seems pointless to go farther if i dont need to. Can you give me an example of something that can be done with ssis and not with a stored proc?

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

All workstations

it's not something that is limited to one server. it's accross all servers.

no it's like the login expires after some time.

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

Thanks mrdenny. I used command prompt to pull up the manual and there are tons of params. there must be something to give me the path, but so far no luck.

Any one know anything about "ls"? it's a unix command apparently that you can call using cygwin. I can't seem to find a combinations of commands to give me what I want though.

problem with that is that I'd have to have the full path to plug it into getfiledetails, which I don't. I have only the starting folder and no info on subfolders. Plus, our conversion to 2005 is in just a few months, so still wouldn't work.

Is this a "file" or just a string of data? Two things are coming to mind depending on what your scenario is: wget or bulk insert

ya, tried that, but that gives even less information. I need filename datemodified or created fullpath size

xp_cmdshell... if you know how I can do it with another command just let me know how.

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

Can't really say, just scares me. I've been told there is a way to get directory information without using cmdshell. If someone can tell me how to do this I can get it to work.

its' 2000 other thing cmdshell is doing is also /dir to get the list of files in a directory.