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...

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...

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

union all

SELECT...

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...

I did something like the following

set rowcount 0

Select id,

case when datecolumn1 is null then 2 else isdate(datecolumn1) end as c1, /*isdate returns 1 when true and 0 when false*/

case...

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...

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...

I run select * from accounts where id = 509416 and the SSMS just hangs there executing the query - even stopping doesn't help, I have...

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...

I agree with Paul. Just look up the SUBSTRING function.

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...

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...

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...

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...

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...