Viewing 15 posts - 6,226 through 6,240 (of 7,429 total)
You can create a linked server to itself by creating an alias in networking client, setting that as the SQL server name and making sure data access is setup....
April 29, 2002 at 5:04 am
Procedures below where created in the chain of execution can see it directly. Thos above where it is created cannot. So where you create in the first and call the...
April 29, 2002 at 4:58 am
Yes I agree with Andy the problem is when it interprets the values they look like '1,2,3,4,5,6' and not 1,2,3,4,5,6. I would suggest usig a temp table and split you...
April 29, 2002 at 4:54 am
Anything else running on the box? Also how much RAM do you have and how much RAM and VM was SQL using at the time?
"Don't roll your eyes at me....
April 29, 2002 at 4:15 am
Depends on you query. If the item is a single update like this then a RID shoudl show but a KEY would not have a negative impact since it still...
April 26, 2002 at 11:09 am
quote:
What about blocking and locking here ?
If you are questioning if it will cause these...
April 26, 2002 at 10:23 am
No keep the clustered index. I was trying to get at that clustered indexes physically order the table, so this would make sense.
"Don't roll your eyes at me. I will...
April 26, 2002 at 8:01 am
Consider this, how does a clustered index work in regards to the tableand what happens if that index is no longer clustered?
"Don't roll your eyes at me. I will tape...
April 26, 2002 at 7:22 am
Ok can you do sp_attach_db to reattch both the MDF and log file (name back first). Then do from QA sp_detach_db rename the log file and use sp_attach_single_file_db. Also I...
April 26, 2002 at 5:11 am
Looks like MDAC 2.6 failed to install properly. Check out http://support.microsoft.com/default.aspx?scid=kb;en-us;Q257716 to see it helps. Or try downloading the current MDAC from http://www.microsoft.com/data/ and installing by itself.
"Don't roll your eyes...
April 26, 2002 at 4:50 am
Thanks Brian. That is good news, have not seend this must find out more.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 26, 2002 at 4:31 am
Try detaching the database then try sp_attach_single_file_db after renameing the log file. However a log size of 0 may not be a true issue, are you getting errors or the...
April 26, 2002 at 4:28 am
Try sp_attach_single_file_db if you have only one log file. From BOL
quote:
When sp_attach_single_file_db attaches the database to the server, it builds...
April 26, 2002 at 4:25 am
I am just expanding on what Steve put out, sorry did not have a chance to check my syntax is right but should be close. You have to look at...
April 25, 2002 at 7:53 pm
Can you post the entire contents of C:\WINNT\sqlstp.log?
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 25, 2002 at 4:11 pm
Viewing 15 posts - 6,226 through 6,240 (of 7,429 total)