Viewing 15 posts - 466 through 480 (of 506 total)
If you use SQL Server 2016 Temporal tables with the right columns such as ModifiedBy can provide data as it was at any given time and who updated it to...
March 8, 2017 at 5:57 pm
Since you're running from your workstation, you must specify the server to connect to regardless of where the script is in the file system. Adding -S Yourservernamehere should resolve the...
February 28, 2017 at 1:26 pm
Unless you're running this on the server you have to specify a server to connect to.
sqlcmd -S myserver -Q "select value from sysconfigures where comment = 'c2 audit...
February 28, 2017 at 12:58 pm
I know this is a completely different approach but check this PS script page: http://www.sqlteam.com/article/fast-csv-import-in-powershell-to-sql-server
February 10, 2017 at 2:51 pm
Check out the documentation:
http://www.cozyroc.com/ssis/sftp-task
February 9, 2017 at 6:01 pm
Using Windows Authentication sometimes if Kerberos isn't configured correctly SSPI contexts don't get passed. This results in the inability to connect. If you're connected but the insert fails silently, that's weird.
February 9, 2017 at 4:30 pm
In this case dynamic SQL would perform better as it complies on the fly. You could have a master procedure that calls different procedures based on the number of set...
February 9, 2017 at 1:40 pm
How is security set up on the linked server?
February 9, 2017 at 1:30 pm
Try:
EXEC sys.sp_MSforeachdb @command1 = N'USE ?',
@replacechar = N'?',
@command2 = N'IF DB_NAME() IN (''db1'', ''db2'')
INSERT tempdb.dbo.acumulation_table SELECT m.name AS Market,ISNULL(usr.first_name,'')+','+ISNULL(usr.last_name,'') AS AE,...
February 6, 2017 at 4:31 pm
The answer is it depends on your requirements. Many organizations run a fiscal year from June to July so it might include fiscal Month column with start and end of...
February 6, 2017 at 12:26 pm
I would create a calendar table with a granularity of day with a StartOfDay set to 12:00:00 AM of the day and a EndOfDay set to 23:90:59.997 (for datetime). With...
February 2, 2017 at 4:46 pm
Try creating a PowerShell script to run it and handle errors in the ps script.
February 2, 2017 at 3:21 pm
Viewing 15 posts - 466 through 480 (of 506 total)