Viewing 15 posts - 46 through 60 (of 1,409 total)
The reason for the number of columns is 2 fold. The first...
April 25, 2018 at 8:14 am
500 columns is a lot to put into a single table. It is also not a good approach to create a seperate table for each quarter.
Take a good look...
April 25, 2018 at 8:11 am
Does the failing stored procedure contains the EXECUTE AS clause?
April 25, 2018 at 7:52 am
April 25, 2018 at 4:50 am
Copying the databases using the SQL backup and restore method should work from SQL2005 to SQL2012. I expect the only thing to take into account during the restore is the...
April 25, 2018 at 4:11 am
The duplicate value is listed in column ID or in column OrigID. So you also have to delete the rows where the duplicate value is listed in the OrigID column.
April 25, 2018 at 3:09 am
March 14, 2018 at 9:11 am
March 14, 2018 at 9:03 am
pietlinden - Wednesday, March 14, 2018 8:29 AM
With the link of PietLinden you can investigate the possibility's. Just try and...
March 14, 2018 at 8:51 am
In the code posted in my previous post it is just the letter "x".
March 14, 2018 at 8:35 am
You must give a name or alias to the sub select part.
I you enter a "x" (or even better: a more descriptive name) between the closing bracket and the...
March 14, 2018 at 8:01 am
March 9, 2018 at 5:04 am
March 8, 2018 at 5:53 am
Have you taken a look at the PowerShell scripts at DBAtools.io?
After a quick glance I guess you can use the function "copy-dbasysdbuserobjects".
Edit:...
March 8, 2018 at 4:53 am
Viewing 15 posts - 46 through 60 (of 1,409 total)