|
|
-
|
|
ecurity is the main thing for servers and sql servers and we need to trace it for security management. Have to need track who are using it, what they are doing and when they performed. For SQL Server 2005 and later versions we have some DDL events which...
|
|
-
|
|
Last time we have seen tablediff Utility basis and tablediff utility for multiple tables using SSIS. As you know using ssis package it generated discrepancies log files for database changes which we have to apply on destination servers\databases to mak...
|
|
-
|
|
Recently we done with conversion of the same topic to copy database backup files to external drive using XCOPY only. That script copy database backup files created on current day from source to destination, So we can scheduled that code to run one time ...
|
|
-
|
|
As a security part, recently I worked with login details and the auditing for the same. I was needed to capture each events for login statistics like login name, the time when logon, the program through established connection, session and host or client...
|
|
-
|
|
As we have seen the last post for the basic concept of tablediff utility. We learned one example using static table, now I would like to go it with SISS package and also using more tables comparison. So, lets start it with some demo objects and created ...
|
|
-
|
|
Earlier we have seen for the Delete file using Script Task and files deletion using File System Task in SSIS. We have directly wrote the logic to get the files and delete from specified folder in the script for the Script Task. For File System Task we have Used Foreach Loop Container and variables......
|
|
-
|
|
Problem:
Before a few days ago i have installed SQL Server Denali CTP3. Then i have querying in query analyzer and found, minimizing result is not working with CTRL+R is not working. Before CTP3 i have already Denali CTP1 installed in my machine and it was working perfectly, So it stopping to w......
|
|
-
|
|
You may worked with Service Broker in SQL Server. I am just learned Service Broker and implemented practically with an examples which i evaluated. Before moving on it i would like to introduce service broker, not in the deep but having some overview.
Service broker appliees to SQL Server 2005 and......
|
|
-
|
|
Last time, i have posted for the new Anaytical functions of Denali CTP3.You can see WHAT IS NEW in SQL Server Denali CTP3. This time i am going to write for new conversion functions which are summarized below,
1. TRY_CONVERT() - Returns a value to be cast to the specified data type if the cast ......
|
|
-
|
|
Recently while working with one query to get schedule jobs status, i used xp_sqlagent_enum_jobs object which gives details of state values of all jobs in msdb database and this is undocumented object. But received an error while running following query ...
|
|