Technical Article


  • Topic

I would like to set up a single server to act as the following:-A Domain Controller for a Windows Active Directory Network-A SQL Server 2000 Database Server-An Analysis Services OLAP server-An IIS 6.0 Web Server-A Terminal Services Server that would allow users to access a couple of fat client VB applications, and crystal reports 8.5 […]


2 reads

Technical Article

RE: best way to copy database from one server to another?

  • Reply

I am fairly new to SQL and have a great automatic way to do this:I have 2 Servers, Windows 2003 Standard, both with SQL Server 2000 and sp3a.I have a folder on the main server d:\mssql\data\backup\ - I made a folder here called "disasterbackupcopy".I have a folder on the backup server d:\mssql\data\backup\ - I made […]


Technical Article

RE: Replace Function does not work on Text Datatype?

  • Reply

If ALL your text data is less than 8000 bytes per record, then you could select replace(Convert(VarChar(8000), comments), '&quot;', '"') from tblcaseinfo where PatIndex('%&quot;%', comments) <> 0 Notice PATINDEX for your search condition.If it's longer, then you have to use UPDATETEXT. see BOL.


Technical Article

RE: Simple "IF" Logic in Package

  • Reply

Thanks Salim. Our needs are much simpler than what the DBPropagator seems to offer. Also, if I can't do this cheap I can't do it at all. Basically, Transactional data is processed on the mainframe and a file(table?) is built/updated. The data then needs to be exported to sQL, which will then continue with the […]


1 reads


Daily Coping 3 Feb 2023


Today’s coping tip is to ask other people about things they’ve enjoyed recently I...

Daily Coping 2 Feb 2023


Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...

Deadline for Microsoft MVP contributions is 20 March 2023


Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...

Read the latest Blogs


Extended Events to capture query causing tempdb log to get full


Hi! Query store provides information on workloads on tempdb How\Steps to setup Extended events...

How to append data to the previous row

By jay-125866

Hi, I have a table that stores event transactions, the sample data see the...

Replacement for char and ascii functions in natively compiled stored procedures

By MullerN

I am trying to create a natively compiled stored procedure where I need to...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers