TJ-356724 (10/3/2012)

---

Running DBCC CHECKCATALOG ('TWORKS') WITH NO_INFOMSGS produces some errors as follows:

Server: Msg 2513, Level 16, State 2, Line 1

Table error: Object ID 544525519 (object '544525519') does not match...

What does this say on the instance causing the issue:

SELECT SERVERPROPERTY('Edition') AS Edition,

SERVERPROPERTY('ProductVersion') AS ProductVersion,

...

OK, you have orphaned columns for a table that no longer exists. Here is how you can correct the problem on the 2000 instance:

http://msdn.microsoft.com/en-us/library/aa258741(v=SQL.80).aspx

** Take a FULL backup first and...

On which system, 2000? or post-upgrade on 2008?

K. Brian Kelley (10/3/2012)

---

opc.three (10/3/2012)

---

K. Brian Kelley (10/3/2012)

---

opc.three (9/28/2012)

---

If I had to say one thing about Groups I would try to avoid adding Windows Group to the sysadmin Role. I...

K. Brian Kelley (10/3/2012)

---

opc.three (9/28/2012)

---

I agree with that in theory. In my experience however, in practice, when a new person is brought into an environment the request usually looks a...

I cannot recreate the issue. Maybe it has been fixed. Here is the SQL I see when I script the 500-column VIEW as an ALTER:

exec sp_executesql N'SELECT

p.name AS [Name]

FROM

sys.all_views AS...

Before going for BULK INSERT which implies there will be a directory where a file can be written that both the app and the SQL Server can reach I would...

Jeff Moden (10/2/2012)

---

That fact...

Mapping XEvents to Trace Events by Jonathan Kehayias

The mapping is more complete in SQL 2012.

Regarding the results being discarded, that's true for some targets like the ring buffer. You can...

Jeff Moden (10/1/2012)

---

It's simple....

If you have the time and inclination to provide proof-of-concept code that could be used on any instance to reproduce the issue it would be helpful to the community if...

Properly locking down your system, what exactly do you mean by that?

SSIS NULL Function

SSIS Replace Function

Example where 10 is the length of the string and 1252 is the Encoding:

REPLACE(IncomingColumnName, "String you want to replace", NULL(DT_STR,10,1252))

Example where 20 is the length of...

I guess you are not using SSIS Package Configurations to store Connection Manager info. If you are you can simply change the config files and the code will not need...