Just to make sure I understood the Intersect/Except operators, I tried a variation of the examples from BOL. I put debug(s) around it all just to run various tests without...

I found a bug listing on Microsoft Connect (ID 515132) similar to the issue I was experiencing. I put my comments in the bug and voted on it. Anyone experiencing...

No updates. When the problem first occurred there were no postings on the subject related to SQL Server 2008... I am beginning to see some now, but no answers on...

This is an older post (I was researching a similar issue). Check the following URL:

http://www.sqlservercentral.com/blogs/sql_performance/archive/2010/2/5/microsoft-sql-server-2005-cpu-scheduler-id-is-not-synchronized-with-other-cpus.aspx

Ok... found a temporary solution to the problem, but still not understanding why it is happening.... played with firewall settings (Windows Server 2008 has multiple firewalls).

Used the ipaddress,port (for...

Just to see what would happen, I did try and use a remote desktop connection to the server and it worked fine! Dealing with a few other issues now too......

I am just completing a migration from SQL 2005/Win2003 to SQL 2008/Win2008. Here are some links to review:

1) Review this forum entry: http://www.sqlservercentral.com/Forums/Topic843135-1550-1.aspx

2) Here is a good...

Charles,

Thanks for the update. I was just getting ready to post this myself... I just figured that technique out this week when I had some 250-row csv files I...

Unfortunately no, never found a solution for this. I did have to manually add each column name (and datatype) to the flat file connector.

One word of caution (just found...

Here is a bit more of an update....

First, you can get errors in SSIS that would not fail in SQL Server (in this case, when Ignore_dups is set on)........

Not that I am trying to take over someone's elses post, but here was the example query I was using:

SELECT CONVERT(varchar,Invoicedate,101) as PostedDate ----- Group by date as there...

Unfortunately I do have to do all of those contortions as I am using CONVERT(varchar,InvoiceDate,101) in the SELECT statement and the GROUP BY. If I just try and use just...

I know that I had a similar problem with some of my reports... I would convert the date to a varchar to eliminate the time component, i.e., CONVERT(varchar,InvoiceDate,101) as InvoiceDate...

For anyone else researching the "sp_MS_marksystemobject", I found the following excerpt from Kalen Dalaney:

http://sqlblog.com/blogs/kalen_delaney/archive/2008/08/10/geek-city-system-objects.aspx

Kalen says:

...The objectproperty function has an argument called 'IsSystemTable', that will show you...

Thanks! 🙂

I was hoping the solution might be something simple. Here we go:

EXEC sp_msforeachDB 'USE ?; DECLARE @Name VARCHAR(30), @NewName VARCHAR(30), @Statement varchar(1000);

SET @Name = ''Smith''; SET...