Viewing 15 posts - 1,051 through 1,065 (of 1,076 total)
One benefit of instances is that when you create a linked server connection to a database in another instance (of the same machine) then data does not have to travel...
July 15, 2009 at 10:03 am
If you created the SSIS package under a Windows account then you can create a Proxy object to run the job under. The way I understand it a proxy treats...
July 13, 2009 at 1:45 pm
You can then create a view as a UNION ALL of the those two tables and use that for simplicity.
SELECT * , 1 as 'party' FROM myproducts
July 13, 2009 at 1:12 pm
Hi and thanks for your replies --
Accounts is a table, thus there are no calculations occurring.
I will post any news I have for I am working away on isolating the...
June 12, 2009 at 10:17 am
I did something like the following
set rowcount 0
case when datecolumn1 is null then 2 else isdate(datecolumn1) end as c1, /*isdate returns 1 when true and 0 when false*/
June 11, 2009 at 4:37 pm
Hi Kal -- I'm not the original author of this thread. I am just issuing my own grievances with the same message the author gets. All of our date columns...
June 11, 2009 at 4:00 pm
I should be a bit more clear:
I can query all the date fields in the record mentioned (id 509416). They show up as a date or as NULL. But the...
June 11, 2009 at 3:42 pm
I run select * from accounts where id = 509416 and the SSMS just hangs there executing the query - even stopping doesn't help, I have...
select * from accounts where id = 509416
June 11, 2009 at 3:38 pm
We get this error when we select * on one of our records in one table (using like where id = 12345). I can see all the dates and nulls...
June 11, 2009 at 2:00 pm
I agree with Paul. Just look up the SUBSTRING function.
June 9, 2009 at 3:08 pm
I experienced this problem after I installed a service pack. I opened the "configure report service" application on the server machine. In report manager virtual directory settings I checked the...
June 9, 2009 at 3:04 pm
I know there are many possibilities but one thing I would consider is if the SSIS package runs while many client apps are connected to the server. Thus there would...
May 18, 2009 at 4:39 pm
A good bet is to create the package as the very user whose credentials are used to run the package. The user should be a member of the role(s) needed...
May 18, 2009 at 3:44 pm
Okay I guess I am not clear on your objective. Can I ask how you are inserting records? Without bulk load they are commited one at a time. Do you...
May 18, 2009 at 3:29 pm
Bulk loads I am quite sure bypass triggers. To use the sp_send_dbmail procedure you have be an admin or the login should be given the securable DatabaseMailUserRole (a schema) pertaining...
May 15, 2009 at 4:48 pm