Viewing 15 posts - 25,516 through 25,530 (of 26,490 total)
To use CLR stored procedures, your database needs to be in Compatability Mode 9.0 (SQL Server 2005).
![]()
August 28, 2007 at 3:49 pm
I am assuming that you have created some procedures in the master database that you have named sp_xxxx. When you run those in a user database are you calling with...
August 28, 2007 at 3:47 pm
When we upgraded our PeopleSoft Financial System database from SQL 2000 to SQL 2005, we had similiar issues. We initially used DTA to identify new indexes, and ended up adding 37...
August 24, 2007 at 2:37 pm
Fully aware of using SQL to start jobs, or using xp_cmdshell to execute command line programs. Starting a job is asyncronous, and would require additional coding in both the job...
August 24, 2007 at 10:16 am
This is the link in BOL I started my research with:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/dtsref9/html/2f9fc1a8-a001-4c54-8c64-63b443725422.htm
![]()
August 22, 2007 at 1:51 pm
Could you also provide the full code for the stored procedure? One thing most will jump on is the possibility of parameter sniffing (search this site for more info on...
August 22, 2007 at 1:47 pm
At my last employer we logged ftp transfers to a SQL Server database table on one server (using virtual directories, the files actually we loaded to a second server) to...
August 22, 2007 at 1:28 pm
Why would I need to allow and use unsafe assemblies in the database? So far in my research I haven't seen that, but of course, I may not have gone...
August 22, 2007 at 1:04 pm
Glad to help, and from what you said above, I assume it worked okay.
![]()
August 22, 2007 at 9:09 am
Okay, I was looking at one of my packages, and I think I know what you need to do.
Edit the Execute Process task. Select Expressions. Click on the ellipses button...
August 22, 2007 at 8:33 am
Please post, at least, the tables ddl (what do the tables look like?)
August 22, 2007 at 8:00 am
It really is only a work around. If your table gets big enough, it will stop working. A view, returning all rows is treated as a table, the order of...
August 21, 2007 at 2:18 pm
I've noticed if you cut and paste directly from QA or SSMS (where everthing is single spaced) ends up double spaced here. I usualyy use UltraEdit as an intermediare so...
August 21, 2007 at 11:19 am
select top 100 percent ... ORDER BY ..., SQL Server 2005 ignores the order by clause. This is actually how it should be handled. There are several discuss threads on...
August 21, 2007 at 11:13 am
The problem you are having is a collation conflict. Somewhere in your query, you are comparing two character fields that have different collations. Without knowing which tables are using which...
August 21, 2007 at 9:37 am
Viewing 15 posts - 25,516 through 25,530 (of 26,490 total)