Viewing 15 posts - 5,326 through 5,340 (of 7,429 total)
Sounds like you have a gap in your transaction log. A lot of times it is how you perform your full backup and if you do a shrink database and...
June 25, 2002 at 4:02 am
quote:
i do not want to use cursor or stored proceduere is there any way to solve this in one query.
June 25, 2002 at 3:59 am
I got this the other data and found a problem with the table and it extent listing. Of course the message confused me but I had recently use the table...
June 24, 2002 at 8:34 pm
With a search criteria the count should be coming strictly from the table and not sysindexes as the count must reflect the results of your criteria set. Also of note...
June 24, 2002 at 8:30 pm
I was in that thread. That effects seems to only occurr on SQL7, never got anyone at Microsoft to answer that for me. 2000 seems right in line as soon...
June 24, 2002 at 8:26 pm
I also have posted a method of creating a temp table parse the values into it then use IN (SELECT colvals FROM tmpTbl). I will find a thread later or...
June 22, 2002 at 12:41 pm
One thing of note is that if SELECT * INTO it will create locks for the duration of the process. It is usually better to build table by CREATE TABLE...
June 22, 2002 at 12:39 pm
Using the INNER JOIN keyword to make your join like so will help the query engine make faster join analisys as oppossed to the old WHERE clause way as well.
...
(select...
June 22, 2002 at 12:35 pm
Also I am confused, you state you are experiencing many memory leaks. I have been involved in the SP betas and using SQL in bland form on a test server....
June 22, 2002 at 12:30 pm
I believe your problem is related to this article http://webferret.search.com/click?wf,+%2Bdts+%2Bis+to+large+for+the+specified+buffer+size,,support.microsoft.com%2Fsupport%2Fkb%2Farticles%2FQ281%2F5%2F17.asp,,aol in regards to typerguess from Jet4.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston...
June 21, 2002 at 9:24 am
The user must be connected to the Domain that governs the SQL Server installation. I use both Windows Authenication and SQL Logins. I have seen no specific issues with SQL...
June 21, 2002 at 8:49 am
Sorry should have typed
SET ROCOUNT 10
not = 10. My mistake.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 21, 2002 at 8:09 am
Sounds like the lenght of the field you are inserting into is smaller than the data coming in. Check your table where column 17 is being inserted and check the...
June 21, 2002 at 6:21 am
Explain how this app works and is it inhouse or third party. If third party and doesn't have a built in piece for the security you can adjust then put...
June 21, 2002 at 5:56 am
From BOL
quote:
Execute permissions for xp_cmdshell default to members of the sysadmin fixed server role, but can be granted to other users....
June 21, 2002 at 5:44 am
Viewing 15 posts - 5,326 through 5,340 (of 7,429 total)