RE: Help Registering an Analysis Server
After adding your account to the group you just have to log off and then log on in the client. Also, make sure you have the same Service Pack on both the server and the client.
2003-12-17
database
RE: Improvement in Select with Sql Server
I would say, that EXISTS almost always performs better, because it can stop once the logical test is true, while COUNT walks through the whole resultset, even after the condition is met. Frank http://www.insidesql.de http://www.familienzirkus.de
2003-12-17
1 reads
RE: QOD 12/17/03
Wrong "correct answer", but right Explanation... QOD is getting worse every day. Yesterday it was a minor mistake about an underline, today is a huge difference between DESCending and ASCending. Needless to say that I answered "None of the above" and... I want my points back ! Razvan
2003-12-17
RE: Running DTS packages from ASP
Here's the code that connects to the database Const DTSSQLStgFlag_Default = 0 Const DTSStepExecResult_Failure = 1 Dim oPkg, oStep, sErr, bSuccess Dim sServer, iSecurity, sUID, sPWD, sPkgName, sPkgPWD ' Get Form Variables sServer = Request.Form("txtServer") iSecurity = CInt("0" & Request.Form("optSecurity")) sUID = Request.Form("txtUID") sPWD = Request.Form("txtPWD") sPkgName = Request.Form("txtPkgName") sPkgPWD = Request.Form("txtPkgPWD") ' Validate Variables […]
2003-12-15
RE: OSQL return codes
If there is a dos errorlevel of 0, then the query succeeds. The query in other words returns a 0. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones The Best of SQL Server Central.com 2002 - http://qa.sqlservercentral.com/bestof/ www.dkranch.net
2003-12-08
2 reads
RE: sysdepends
Sysdepends ends up not being very reliable. Plus, it has no concept of cross db dependencies, so you end up keeping track manually anyway. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-11-21
RE: Server name changed
It's been a while since we replace sql 7 but I think you have run set up for sql 7 again to get the server you rename to work. Please don't feel too worry if it ask you to run set up. Go ahead and run setup from your software network file or cd, and […]
2003-11-20
RE: best way to denote a numbered item
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-25
2003-08-25
RE: SQL Server script
Hi, I am in an in house project, so fund allocated for this. I am sorry ! Any alternative? Thanks Jac
2003-08-14
Blogs
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned...
EightKB 2024 – Schedule and Registration
Hello Hello, We. Are. Back! The schedule for EightKB 2024 Edition has been announced!...
Inside SQL Server Backup and Restore History Pruning with sp_delete_backuphistory
By Steve Jones
I had a customer that was looking to document a restore that had occurred...
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