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 […]
2004-07-22
2 reads
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 […]
2004-07-22
How about DTS packages, stored procs, views, etc. that were created in 7? Are there any special considerations there?
2004-06-17
yes i did. i am actually running the job as the sqlservice agent account.
2004-01-12
2004-01-05
1 reads
If ALL your text data is less than 8000 bytes per record, then you could select replace(Convert(VarChar(8000), comments), '"', '"') from tblcaseinfo where PatIndex('%"%', comments) <> 0 Notice PATINDEX for your search condition.If it's longer, then you have to use UPDATETEXT. see BOL.
2004-01-05
2004-01-05
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 […]
2003-12-08
1 reads
2003-12-02
1 reads
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-08-18
By Steve Jones
Today’s coping tip is to ask other people about things they’ve enjoyed recently I...
By Steve Jones
Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...
Hi! Query store provides information on workloads on tempdb How\Steps to setup Extended events...
Hi, I have a table that stores event transactions, the sample data see the...
I am trying to create a natively compiled stored procedure where I need to...
Ask SSC