I would like to share the script to find out the scheduled jobs which call SSIS packages in SQL Server. [CODE] SELECT sj.job_id as JobId, sj.name as JobName, sjs.step_name as StepName, sjs.Command as Command FROM sysjobs sj INNER JOIN sysjob

To delete the files using Ole Automation Procedures in SQL Server we need to first enable 'Ole Automation Procedures' using sp_configure as following, [CODE] exec sp_configure 'Ole Automation Procedures', 1 go reconfigure go [/CODE] After enabli

Earlier i submitted script to upload file(s) via FTP in SQL Server here http://beyondrelational.com/justlearned/posts/600/script-to-upload-files-via-ftp-in-sql-server.aspx. You can find here the same but it's for download the file from FTP. [CODE] DE

I just go through the SQLCMD command line utility to perform database backup in sql server where it does not have sql agent. Below is the command which i placed in batch file and schedule with windows task scheduler. [CODE] Sqlcmd -UUserName -PPassword

I faced this error mentioned in title while running stored procedure in local server which updates data in remote server. I was able to fetch data from remote server but couldn't update through linked server. I checked the linked server and access but it w

I encountered an error mentioned in title from log reader agent after reinitialize all subscription for one publication and it stopped working. This is due to replication object was not created for insert and named like 'sp_MSins_TableName'. The soluti

Replication was stopped for one subscriber database due to memory issue with following error, [CODE] Error messages: There is insufficient system memory to run this query. (Source: MSSQL_REPL, Error number: MSSQL_REPL27453) [/CODE] It got resolved

During working with replication, encountered with one error to use actual server name for replication. For solution we need to change the SQL Server instance name as actual server name with following, [CODE] EXEC sp_dropserver 'Old Server Name' EXEC s

You may read earlier post to add transactional publication in replication here http://beyondrelational.com/justlearned/posts/730/adding-the-transactional-publication-in-replication-sql-server.aspx, here how can we add a transactional pull subscriptions to

We can add indexed views in transactional publication same as normal views (http://beyondrelational.com/justlearned/posts/701/.aspx) for transactional replication. [CODE] USE PublisherDB GO EXEC sp_addarticle @publication = N'PublicationName',