Viewing 15 posts - 25,516 through 25,530 (of 26,487 total)
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
I am trying to figure out your concern over the duplicated data. Yes, the data is dupicated from the base tables to the indexed view, but this is controlled by...
August 21, 2007 at 8:35 am
How would you run an SSIS package from T-SQL?
![]()
August 21, 2007 at 8:24 am
Can you provide the DDL for all the tables involved? In the script, be sure to include the collation of the character fields.
![]()
August 21, 2007 at 7:49 am
Viewing 15 posts - 25,516 through 25,530 (of 26,487 total)