Viewing 15 posts - 1 through 15 (of 27 total)
muthyala_51 (6/3/2014)
Can the script.sql file can have a select statement with joins? or this can be only used to export for just plain tables?
There is no restriction on what SQL...
June 4, 2014 at 5:37 am
it.ma (6/3/2014)
It says
"You cannot call a method on a null-valued expression.
Line:16 / Char:18
+$ds = $server.Databases[$database].ExecuteWithResults("$(Echo $1.OpenText().ReadToEnd())")
+
+ CategoryInfo :...
June 4, 2014 at 5:35 am
Jeff Moden (6/3/2014)
I realize that $dt is a loop variable but what did you intend that "dt" stand for? I'd also like to know why the use of...
June 4, 2014 at 5:35 am
sql_er (6/3/2014)
Will it properly extract .csv file and show in excel if some columns are nvarchar and contain data in Russian for example?
One good way to find out is to...
June 3, 2014 at 4:45 am
it.ma (6/3/2014)
where do we need to keep this master.sql script file? same directory where the PowerShell script resides?
Yes, same directory.
June 3, 2014 at 4:43 am
swebster (4/28/2014)
I can write...
April 28, 2014 at 7:25 pm
Steve Jones - SSC Editor (4/8/2014)
Louis Li (4/7/2014)
Submitted.
Louis, I see a script from you and that's good, but I'm still looking for an article with explanation of how to do...
April 23, 2014 at 4:09 pm
The result returns tables and all indexes, you see multiple rows of same table because these tables have indexes created on them. They are not related to fragmentation or operation...
January 21, 2014 at 10:59 am
First line of this script should be
SELECT
Add SELECT as your first line, anything else seems OK.
January 21, 2014 at 10:07 am
Carolyn S. White (1/20/2014)
Does it work...
January 20, 2014 at 9:02 pm
Can you copy / paste the script from your SSMS here?
January 20, 2014 at 8:49 pm
Viewing 15 posts - 1 through 15 (of 27 total)