Recent content by daglugub37

thanks all. Very Helpful

Hi all, ok I have a sql 2000 server that has experienced some memory shortage issues. I was hoping to get some info via Enterprise Manager | sql server logs...but the size is 5.5 megs and EM just hangs. Where\how can I open the error log?

OK I am setting up a linked server through Enterprise Manager. I am on a SQL 2000 server and trying to LINK to a SQL 2000 Analysis Server. So I name it, choose the right provider, configure some provider options, give it a datasource server name and lastly a catalog which I figure equates to...

SO an update was taking much longer than expected. The sql was not wrapped in a transaction. I killed it expecting it to just stop, and whatever was updated remain. Instead it is rolling back. Can I kill this rollback,

thanks all, for some reason i was making it more complicated then it needed to be.

OK I have 2 identical tables. table1 col_ID colA colB table2 col_ID colA colB How can I update table1.colA, table1.colB from table2, using col_ID as a join?

Thanks, I figured as much. Since I happen to be experiencing a slow crash :) I thought as a matter of preparation(to go ahead and deactivate(online) the key now....but it seems it is just best to call if I have a problem on activation. BTW - I was just reading that only a m-board or case...

Before I reinstall XP Pro, do I need to go online and deactivate the key? Once I reinstall I am going to need windows updates, and I don't want it to tell me this is a 2nd instance or anything like that. How does this work?

thanks all. I will search processes via google but also armed with the knowledge that nothing really critical is listed in startup I will lean more towards disabling unknown items. In regards to McAfee(maybe all Virus suites). First I am going to stick with it for now as I only recently paid...

Hi All, I plan on addressing some long over due cleanup on my xp pc tonight. Basically it has become bloated a bit slow, maybe even some virus deletion. Basically my plan is this. 1. Run a full virus scan 2. Any virus defintions found look up and perform cleanup steps 3. Reconfigure my Mcafee...

Thanks. I just copied over RDS and RDL files and added them to a new solution. Actually when you try to view the copied datasets it will tell you what data sources it was looking for. The Build\Deploy went well and the 2nd instance of this report is now working from an alternate location...

OK so I did just copy the RDL file to the new server. I created a new project, and added an existing RDL. Unfortunately the RDL was just one of many in the source project, and also there is many datasources. This RDL I am trying to copy has 3 datasets....I can't seem to ascertain what data...

Hi, I am totally new to reporting services. I would like to copy a report from one server to another. Both are SQL 2005 servers. I found the RDL file for the report on the source server, do I just need to copy that file over or is there more to it than that

thanks, I am all set

I got a db in ssuspect mode that I would like to detach\attach. I get the following error when trying to detach. --------------------------- Microsoft SQL-DMO (ODBC SQLState: 42000) --------------------------- Error 947: Error while closing database 'test_db' cleanly...