You can't as far as i am aware, to get what I think you want you will need to give the parameter in the dataset a defulat value of GETDATE()...

Nice demonstration, but I find the SSMS tool very poor for creating the diagrams I need, still experimenting with Visio, Visual Studio and Red Gate.

any table names in particular? Are you able to query the tables directly? You can use the system tables to query the columns etc, here is an example of them...

Ah, okay... Have you installed SQL sp2 as you cannot/shouldn't run SQL unless you have SQL SP2(on vista - something about the compatibility). If you don't have SP2 on then...

i find the quickest method and the easiest (unless the DB must be online 27-7) is to detach the DB (10 secs), copy the mdf and ldf files to another...

I've this problem too and the problem is caused by the user used to logon to service. When you install, normally you would use LOCAL SERVICE.

The user for it...

Then do try the SQL Toolbelt, even if you use this as a starting point only. It is so easy to use and is dynamic! So even if other developers...

For items like this I use SQL Toolbelt (specifically Dependency Tracker) - You can download it for a free 14 day trial, but other than that I would recommend keeping...

What version of SQL are you using? Also is the data you are importing the same/fixed i.e. does the structure of the data change? If not have you thought about...

Hi All, I found a rather useful post/blog that did what I was after. The link is below...

http://agilebi.com/cs/blogs/jwelch/archive/2008/02/02/importing-files-using-ssis.aspx

I found one method that use's xp_cmdshell but I can't use as we have our db locked down, anyone have and other suggestions?

USE master

GO

CREATE PROCEDURE dbo.sp_ListFiles

@PCWrite...

Just call another SP in the condition... But would you really want to have 20 SP's each one being called by the other to do the one job? as it...

Here is a code for counting weekdays, you can tinker to get what you want...

CREATE FUNCTION dbo.GetWorkingDays

(

@startDate SMALLDATETIME,

...

Sounds Painfull... I'm guessing you could do using the master tables but there would be quite a complex update code to run. Are you wanting to add the same columns...

Really dumb answer but have you restarted the server? Also have you recently installed any updates you aren't aware of (i.e. Automatic updates switched on).