what is the data type set for the parameter? if it is string as in default then that would trigger the error in the expression.

I do not beleive you can use a prameter against a colculated field like a group total. It may be possible to do something with an expression but that...

You said you are getting mm/dd/yyyy and you need mm/dd/yyyy.

since there are the same thing I fear I am missing something.

I am not sure I exactly understand the question. Is the weight field a sum of a group? If the value is the detail then you can just...

you should be able to run this with a system task in SSIS.

in SMS under security if you find you login you can open the properties and in the properties page you will see server roles. there you can see what...

If this is something you are just trying to add to your knowledge base based on an interveiw question you would need to do some reading into replication methods. ...

I can see what you are saying. I find it is one of those philosophical points of veiw that are so often found in the IT world. I...

I may be missing something but I would create a temporary staging table that I could throw the record set into and then using it as a source table is...

I would advise looking up how to do a substring. If the name you need is sonstant you can grab a set number of characters. There is a...

are you asking how to get them back in synch or what the overall health of the DB is?

There is an add-on you can get that would allow you to veiw them directly in SMS for 2005. The add-on can be found in

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

The file you are...

when you setup a user simply grant them access to only the databases they should be able to access. In the user properties page you only need look at...

In 2000 it was called Service manager and should be available in the program folder from the start menu.

or available at the following

C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlmangr.exe

If the access is an business necessity it might be best to setup a small database and simply store the data from the report. Then using an ODBC he...