Brandie

Why not create a new variable called @DayNumTarget, set the value of that in your config file, and change the constraint to (@DayNum == DayNumTarget)?

John

You're getting the error because you're trying to force a result set into a scalar data type.  Result sets can only be fed into a variable with data type Object....

I think Thom has already answered your question.  But I'm not sure what the purpose of your stored procedures are, especially the first one.  It sets the value of a...

Tom

I've never needed to do anything like that.  But I imagine there's a registry key somewhere that determines how many recently used servers to remember in the Connect...

You don't appear to have attached errors.txt.  In SQLProfile_Resolve_Text.txt, are the last few lines (starting with the line that begins with SELECT) the contents of the @Query variable?  Have you...

Failing in what way - error messages, wrong results, just doesn't do anything?  Please post an example of the @sql that you get from test.sql and the full definition of uspCloneTableWithQuery....

No, you can't do it like that.  You need one "?" per parameter and you need to lose the single quotes from the code in (1).  If you want to...

No, I don't think so.  As far as I know, the query optimizer doesn't take permissions into account when compiling an execution plan.  And if you think about it, that...

But you said you had 100 users?  And you mentioned developers - surely they don't access the database through a website?  Never mind - create the login, create a database...

No, it can't be done with the connection string.  Even if it could, you wouldn't want to, since any user with a little know-how can write his or her own...

Yes, you haven't provided enough information for us to answer properly.  But if you can't or won't use a linked server, then try SSIS or OPENROWSET.

John

Yes, or return dates as dates, and if you need to make it all look pretty, do that in the presentation layer.

John

I'm not sure this a shortcoming of PowerShell.  The standard installation of Windows doesn't include the Active Directory management tools.  If you add that particular feature, you get the Active...

I'm not sure whether sqlcmd comes with the full product or just with SSMS either, to be honest.  But, despite the hollers of protest, we don't install SSMS on servers,...

The script I use isn't quite as sophisticated as Thom's.  However, what I do is keep the options in the config file to an absolute minimum, only specifying what has...