Viewing 15 posts - 31 through 45 (of 45 total)
Hello, still won't work,
I runEXECUTE [dbo].[Compare_Table_Content]
@SourceDB = 'FIRSTDB'
,@TargetDB = 'SECONDDB'
,@SourceSchema = 'dbo'
,@TargetSchema = 'dbo'
...
October 3, 2018 at 2:01 pm
October 2, 2018 at 2:27 pm
October 2, 2018 at 2:22 pm
Apart,
Command(s) completed successfully.
I don't understand how can I use such query.
At what line should I set Database 1 and 2 and Table...
September 20, 2018 at 3:17 pm
Hello @jeff, I was thinking this was a good idea for monitoring SQL Server on real time but maybe I'm wrong.
Do you think my PowerShell script...
July 22, 2018 at 9:49 pm
It was so good I had to script it in PowerShell:
#Provide SQLServerName
$SQLServer ="localhost"
#Provide Database Name
$DatabaseName ="master"
#Prompt for user credentials
$credential =...
July 17, 2018 at 6:17 pm
The query always returns me an error,
I try with
USE master
USE DBNAME
USE HelloWorld
(I have a database called HelloWorld) :
January 11, 2018 at 1:02 pm
In the first example you were using "12.6" in the second example "12.5".
Please use the same value otherwise someone can get confused.
Great article BTW
August 24, 2017 at 3:02 pm
August 14, 2017 at 10:24 pm
Hello, where so I find the Favorite Stored Procedures?
How do I load them into SSMS?
August 14, 2017 at 3:22 pm
You are right, dude, there is no "Advanced Analytics Extensions" for SQL Server 2016.
August 3, 2017 at 2:49 pm
Thank you
USE msdbUSE msdb
go
made the trick.
For make it easy to use I added after SELECT
DECLARE
July 26, 2017 at 6:50 pm
July 26, 2017 at 5:47 pm
The script is not working on SSMS 2016
July 26, 2017 at 4:44 pm
This is exactly what I was looking for!
You saved me a lot of work
April 12, 2017 at 3:09 pm
Viewing 15 posts - 31 through 45 (of 45 total)