Your use of ISDATE may not work as you think.  I would suggest using TRY_CONVERT. Also, what happens if the test for a valid date is false?  You code will...

As two other folks have suggested, doing an upgrade is not a very good approach.

SQL 2000 cannot be upgraded to anything but SQL 2005.  As Grant suggested,  the cardinality estimator...

Do you have a Visual Studio subscription?  It's available there.

Good stuff!

I use the dbatools to do the same things.  https://dbatools.io/commands/

There are a few different commands that copy logins and permissions between servers.

I realize the question is very broad and that is likely due to me not having experience loading transactional data. What I'm getting out of all of the responses...

Me too.

I'm not an SSIS guru by any means, but won't an execute SQL task work?

One of the few SSIS packages I've had to work with does a nightly ETL.  There...

Within the first few sentences of reading this, I wondered if better code would lessen that need.  You pointed that out in the last paragraph.

But, I think I would tend...

Can you use a MIN or MAX on one of the varchar columns?

I also recommend reading Jeff's two articles on Pivots and Cross Tabs.

https://www.sqlservercentral.com/articles/cross-tabs-and-pivots-part-1-converting-rows-to-columns-1

https://www.sqlservercentral.com/articles/cross-tabs-and-pivots-part-2-dynamic-cross-tabs

I did a google search for "Auditing  SQL Server with Triggers"

https://www.mssqltips.com/sqlservertip/4055/create-a-simple-sql-server-trigger-to-build-an-audit-trail/

https://www.sqlshack.com/creating-smart-trigger-based-audit-trail-sql-server/

And, searching SQL Server Central for "Audit Triggers", I found

https://www.sqlservercentral.com/scripts/script-generates-audit-triggers

https://www.mssqltips.com/sqlservertip/1468/designing-tables-for-audit-data-in-sql-server/

https://www.red-gate.com/simple-talk/databases/sql-server/database-administration-sql-server/pop-rivetts-sql-server-faq-no-5-pop-on-the-audit-trail/

How about:

SELECT 
a.[GroupID], 
a.[GroupName], 
b.AgentCount,
c.SkillCount

FROM [ApexCCM].[dbo].[AgentGroups] a

LEFT JOIN (SELECT GroupID, COUNT(*) AgentCount
FROM [ApexCCM].[dbo].[AgentGroupMapping] 
GROUP BY GroupID) b ON a.[GroupID] = b.[GroupID]

LEFT JOIN (SELECT GroupID, Count(*) SkillCount
FROM [ApexCCM].[dbo].[SkillGroupMapping]...

Simple question.  Why not just update both places as opposed to using a trigger?

I'm taking a guess here.

Query the Subscriptions table in the SSRS database.  In the ExtensionSettings column is the XML that might store the path.

Update the column to the new path. ...

This is little to go on. We cannot see your system.

Can you provide something more?  A sample query?  A table structure? Sample data?

See the link in my signature on how to...

If you have zero free space, you may not be able to put a clustered index on the table.

I suggest you add space to the file or filegroup, and attempt...

• This reply was modified 3 years, 8 months ago by Michael L John.