Reputation
1,224
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
4 23 45
Impact
~279k people reached

  • 0 posts edited
  • 0 helpful flags
  • 125 votes cast
Dec
28
asked Calling a SQL Server job within another job
Dec
27
comment Restore a Database to a New database (T-SQL)
I added 'RECOVERY', but still get the same error.
Dec
27
asked Restore a Database to a New database (T-SQL)
Dec
10
comment Login failure when running a SSIS package from a SQL Server job
Yes, it is done in ODBC connection, and the test connection can be established successfully there, but I know know how force SQL Server job use that credential, e.g: userId = dba not the SQL server Agent user.
Dec
10
revised Login failure when running a SSIS package from a SQL Server job
added 303 characters in body
Dec
10
answered how often to run Tablediff
Dec
10
asked Login failure when running a SSIS package from a SQL Server job
Dec
10
accepted error in Execute SQL Task with parameter
Dec
5
comment error in Execute SQL Task with parameter
It is OLE DB connection, referring to a local database.
Dec
5
asked error in Execute SQL Task with parameter
Nov
23
revised Microsoft Visual Studio is Busy
edited tags
Nov
22
asked Microsoft Visual Studio is Busy
Nov
22
asked Simulating having multiple Control Flows in a SSIS package
Nov
4
revised How to Handle Database for Application which Starts from Scratch Annually
edited body
Nov
4
revised How to Handle Database for Application which Starts from Scratch Annually
deleted 16 characters in body; added 5 characters in body
Nov
4
answered How to Handle Database for Application which Starts from Scratch Annually
Nov
3
answered Storing date increments in tables
Nov
2
accepted How to grant a user UNSAFE ASSEMBLY permission
Nov
2
asked How to grant a user UNSAFE ASSEMBLY permission
Nov
1
accepted SQL Server database generate script how to avoid adding PRINT statements