RE: DTS-export truncates text columns?
I found the answer myself: http://support.microsoft.com/default.aspx?scid=kb;en-us;247527.
2003-06-24
locking
RE: SQL Server Agent fails to start - no error msg
Hi Csaba, sorry, from now on I can only guess. quote: This is the content of the latest Agent log (from ...\MSSQL\Log dir): 2003-06-20 09:11:39 - ? [100] Microsoft SQLServerAgent version 8.00.760 (x86 unicode retail build) : Process ID 2003-06-20 09:11:39 - ? [100] Microsoft SQLServerAgent version 8.00.760 (x86 unicode retail build) : Process ID […]
2003-06-20
RE: creating a db user role
Thanks for your info. By the way, to fix the public execute permission, I copied an existing script in this site, and modified it: declare @procname varchar(100), @command varchar(100) declare Crs insensitive cursor for select name as ProcName from sysobjects where type = 'P' order by name for read only open Crs fetch next from […]
2003-06-19
RE: Stored Procedure ?
create procedure MyProc @empid int as select * from emp where empid = @empid Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-06-19
RE: Great Plains Schema
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-06-09
RE: New SQL Server is slower than the old
Hi - back again Thanks again for your thoughts. We've been checking out the RAID - new server has RAID5 but with no battery on the cache memory - able to accelerate reads but not writes. Old server has battery backed RAID5 with read and write accelleration equal, so we're installing a new card and […]
2003-06-03
RE: Dup INSERT problem ONLY in Internet Explorer
Sorry we haven't been able to help. You might try the newsgroups that MS has, see www.msdn.microsoft.com. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-05-30
1 reads
RE: Need Help with CrossTab Report
is this what you are looking for SELECT SD.permnum, SD.firstname, SD.lastname, SD.grade, TT.firstname AS TeacherFName, TT.lastname AS TeacherLName, SUM(CASE SC.TestShortName WHEN 'HMRP' THEN CASE WHEN SC.TestScore < 70 THEN SC.TestScore ELSE NULL END ELSE NULL END) AS PreTest, SUM(CASE SC.TestShortName WHEN 'HMR1' THEN CASE WHEN SC.TestScore < 60 THEN SC.TestScore ELSE NULL END ELSE NULL […]
2003-05-28
RE: Can you run SQL server and IIS on same box?
Perhaps I shouldn't save the numbers then. I do not have the option of a different server. The project doesn't have the budget. I can just have the clients sign up for a year. and make them log in one time per year to re-up. I was just thinking I could write the contract such […]
2003-05-25
RE: using profiler
Profiler will help you determine what queries are being executed. You can use a trace along with the Index Tuning Wizard to get some suggestions on how to go about attacking performance issues. That'll get you started. From there you can start looking at the longest running queries (though admittedly quite a few people have […]
2003-05-23
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers