Viewing 15 posts - 43,066 through 43,080 (of 49,571 total)
Nandy (11/20/2008)
Let me explain the issue, I have written the stored procedure to delete the data from the table based on some certain conditions. To check each row with the...
November 20, 2008 at 9:14 pm
The system resource database must be in the same place as master. Where did you place the new master database?
November 20, 2008 at 9:10 pm
bang725 (11/20/2008)
I want to do further processing on this table that is too by another cursor.
Not enough information. If you want help, please give us enough info to help you....
November 20, 2008 at 9:06 pm
Garadin (11/20/2008)
November 20, 2008 at 4:21 pm
Something like this.
SELECT col1, col2, col3 from
t1 inner join (select col1, col2, col3 from t2) t2 on t1.col1 = t2.col1
I'm not sure I understand what you're doing. Please can you...
November 20, 2008 at 4:16 pm
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to
http://www.sqlservercentral.com/Forums/Topic606008-146-1.aspx
November 20, 2008 at 2:11 pm
Try moving the subquery into the from clause and treating the subquery as a table.
November 20, 2008 at 2:09 pm
What do the tables look like? What are the indexes?
November 20, 2008 at 2:07 pm
yulichka (11/20/2008)
Thank you This is 2000 and there is no option for that.
Then read up on DBCC DBREINDEX
Please post in the correct forum from now on.
November 20, 2008 at 2:02 pm
Databases need free space within them. They're not like word documents where white space is wasted. You should leave a fair amount of free space within the data file. If...
November 20, 2008 at 2:00 pm
Garadin (11/20/2008)
November 20, 2008 at 10:46 am
yulichka (11/20/2008)
How you do that?
How do you do what? Rebuild indexes?
Look up ALTER INDEX in books online.
November 20, 2008 at 10:38 am
yulichka (11/20/2008)
How can I check how long I was shrinking a database. Is there a log to check or script to run?
Why are you shrinking the database?
November 20, 2008 at 10:38 am
Script out the logins, with their sids and apply that script on the new server, then you can detach and attach the database without the users been orphaned.
November 20, 2008 at 10:34 am
Viewing 15 posts - 43,066 through 43,080 (of 49,571 total)