The simplest solution to this is to not have different names on the prod and test databases. If you're stuck with both db's on the same server/instance (for whatever reason), do use search and replace. It will make your life easier. The path down dynamic SQL lane has been regretted by many - it should […]
2004-01-22
Execute the following stored procedure just as you would any other.EXECUTE msdb..sp_start_job @job_name = 'your job'You must be a sysadmin to start a job that you do not own.Norman
2004-01-19
Interesting!http://lists.isb.sdnpk.org/pipermail/comp-list/2003-January/001741.html
2004-01-18
Thanks, for the help! I do have one final question though - after adding the link do I need to drop the link or anything like that?
2004-01-16
May be you need to check execution plans. I suppose that for fast example it was build better execution plan because SQL Server has real values of parameters during building of query execution plan.
2004-01-16
I should have held off on posting this question. I have worked through and found the problem and solved it.VS.Net does not fully trust network locations. In my case, my code and binary were being stored to a mapped network drive, so when I went to execute the binary, it would fail when it tried […]
2004-01-14
1 reads
Been there, done that... in my case way back in the days of VFP3, and I still find VFP (now VFP8) the best front end to work with for SQL.Anyway, to start with, use the VFP upsizing wizard to copy your database to SQL. It will move structure only or data as well, as you […]
2004-01-14
Yes, the sqlserver agent account is member of the windows admin group, I am logged in as the sqlserver agent account. I can run the package fine manually but when I ran it through a job, it fails. The sqlserver agent account has also the System Admin rights on the SQLServer. Do I need to […]
2004-01-12
1 reads
2004-01-09
1 reads
Server: Nachr.-Nr. 8115, Schweregrad 16, Status 1, Zeile 1 Arithmetic overflow error converting IDENTITY to data type int. Arithmetic overflow occurred.
2004-01-09
1 reads
In the modern data-centric landscape, SQL stands out as the dominant tool. It's essential...
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers