RE: SQL Enterprise Manager - Problem with connection
Hi all,Thanks "sswords" for ur useful information .... and also "alzdba" for ur prompt reply and helpful hand.
2005-03-07
database
Conditions that cause SQL to change its dynamic listener port.
I was wondering if anyone could tell me or point me in the direction of a white paper. When SQL 2000 SP3 is configured for dynamic port allocation, what conditions would cause it to change its port? IE I need to be aware of Listener port changes.Thanks
2005-02-02
1 reads
RE: A complex problem
Hi, try this one, I hope it will help: select bh.Tank_no, bh.Start_time, bh.End_time, ts.Output_Reading - te.Output_Reading as Trend_Tonne, eds.Output_Reading - ede.Output_Reading as External_Data_Tonne from Batch_History as bh inner join Trend as ts -- Trend start on (ts.Tank_no = bh.Tank_no) and (ts.Time_Stamp = bh.Start_time) inner join Trend as te -- Trend end on (te.Tank_no = bh.Tank_no) […]
2004-12-23
RE: Restore Database to new SQL Server from backup
and to add to Osoba you will need also ,REPLACE if the files existsRESTORE DATABASE MyNwind FROM MyNwind_1 WITH NORECOVERY, MOVE 'MyNwind' TO 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\NewNwind.mdf', MOVE 'MyNwindLog1' TO 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\NewNwind.ldf', REPLACERESTORE LOG MyNwind FROM MyNwindLog1 WITH RECOVERY
2004-12-21
2004-12-03
RE: execution plan differences
actually all three are currently backups of productionso yes they are identical
2004-12-01
RE: Stored Procedure Problem - Exits Prematurely?
Fair point but this wouldn't work if your SP was kicked of by another server process (say, a batch job).I do generally dissagree though... you should always have error handling in your procedures.It's true that serious errors just kill the procedure before your error handler kicks in and you need to cater for that, but […]
2004-11-18
RE: Insert daily records from one table to individual merchant tables
Hi,If it helps - yes you can do away with cursors and still step through everything:- SET @PK = (SELECT MIN(PK) FROM #Values) SET @MaxPK = (SELECT MAX(PK) FROM #Values) WHILE @PK <= @MaxPK BEGIN--Do whatever you are doingSET @PK = (SELECT MIN(PK) FROM #Values WHERE PK > @PK) ENDThough i'm not too certain what […]
2004-11-02
RE: Invalid class string when running DTS pkg as scheduled job
I have had this error message when attempting to run a dts package connecting to Oracle when the package was designed on a computer with the Oracle drivers but I was attempting to run it from a computer that did not have the Oracle drivers. Could you be running the job from a different computer […]
2004-10-11
1 reads
RE: Error while running DTS package
Is is possible that your Ingres table has a column of a custom datatype that SQL Server has no known equivalent for? Or a size that SQL Server can't handle? You might try pulling one column, and if it works, add a second then a third, until you determine what the problem column is. Once […]
2004-10-11
Blogs
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
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