RE: INSERTING IN TEMP TABLE THRO DYNAMIC SQL
That's what I meant to show in my post above. It should also work with temp tables.
2004-03-03
Transaction Log
RE: Maximum length of a Varchar Variable
How did I keep the nice format? I cheated!!!!!!!!!!!!!!!!!!I copied the code into Notepad, fixed the format and then copied that into the reply text box.-SQLBill
2004-02-27
RE: SSC Problem Report
What is the procedure for starting MSSQL Server in Single User Mode. When I give the command \mssql7\binn\sqlservr.exe -c -m from the Command prompt the server starts coming up but after a few mins it halts. In short the sql server does not start in single user mode on my PC.
2004-02-23
Question of the Day for 17 Feb 2004
Comments posted to this topic are about the Question of the Day for 17 Feb 2004 posted at http://qa.sqlservercentral.com/testcenter/qod.asp?QuestionID=183.
2004-02-16
1 reads
QOD Suggestion
Dead line should be imposed for QOD.Otherwise people can look the answers from the newsletter. This will esential for monthly contest.
2004-02-13
Open a webpage over ssl and process results
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!
2004-02-02
RE: Disk performance issues
Looks like an Access design http://qa.sqlservercentral.com/columnists/sjones/pagesize.aspYou should try to stay within the limit mentioned in the article or rethink your design.
2004-02-02
RE: Gost process
It should go away once the rollback is complete. Can you kill the like process on the oracle side?
2004-01-30
1 reads
RE: Closed Recordset returned?? WHY?
I did a few tests:CREATE PROCEDURE [dbo].[tblVarTest] AS declare @TableVar table ( uid int) insert into @TableVar (uid) values (1) insert into @TableVar (uid) values (2) insert into @TableVar (uid) values (3) insert into @TableVar (uid) values (4) select * from @tableVarGenerates the same error when called from ADOCREATE PROCEDURE [dbo].[tblVarTest] AS SET NOCOUNT ON […]
2004-01-13
SQL 2000 Slow Response Times
HiI'm running SQL 2000 (SP 1) on Win XP with 512 RAM.I've got 15 databases loaded. Everything has been running great for a couple of months but since last week the general performance has gone down tremendously. Simple things like opening the Database Drop-down in Query Analyzer or displaying the databases in Enterprise Manager takes ages to complete.To […]
2004-01-13
1 reads
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