Search results for query: *

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,

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?

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?

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...

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

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...

I am looking at one of those darned Agent jobs that have a step of DTSRun /~Z0x180001C1D150E8FA3C8541A9C2030287D03D9D175D94B3CE4D88A2810A4F7446DC3B6C5B996B4C63767EB6B4E670199ADB452DBB70AD4DD48F3F95F48908F541186BAA2E4820E8535F5CE3FFB28B4B227C793C6FBB2581F29C4A5EB45FEFD72F06FAFDFB335B935F543A2B...

So I have a 5 button mouse and I use the run line a lot. Somehow I had one of the buttons assigned to bring up the run line. But now I have a new PC and I forgot how to configure the mouse to RUN. I know WIN key + R, works...but the Windows key is not accepted to include as a key combination...

Hi All, I just got a new PC, with SQL 2000 Client tools. One difference from my new and old PC is that from within DTS designer, datapump tasks; I can not see the full name of objects I am importing\exporting. With my old PC, the drop down list window width seems to expand to facilitate the...

Is there a way to find out how much space all databases of a particular server are using? Not allocated space but an actual sumation of space used across all databases

Hey All, so I have 1 particular server which is having xp_sendmail issues. It just hangs so the email never goes out and proceeding logic never gets processed. The only solution I have at this time is to restart the SQL service which buys us several hours before it stops working again. This...

any experience with this error. Only 1 developer is having a problem authenticating to "most but not all" sql servers through query analyzer or enterprise manager. A SQL authentication will work. Servers are set for mixed credentials and all is working fine for everyone else. Reboot has not...

I would like to somehow assign a rank to rows in a record set. The query is simple enough select * from sales order by gross desc but how could I assign a rank to the results? Meaning the top gross would be #1, and if there are ties then to assign the same rank. I know there is new...

Lately we have been running out of space for the tempdb log. I just do a quick fix truncate of the log but I can not identify one common transaction that is singularly causing the log file to take all remaining drive space. I am wondering if maybe we have run into this scenario as a matter of...

Is there anyway I can retrieve a temp table(# table) if I closed the session that created it? Can I query the temporary database for it?

Hi All, we are on slow migration to SQL 2005. I am studying some of the changes. One being the further shielding of Administrators to work directly with system and or database catalog tables. In 2000, there were a few views and hundreds of system procedures reduced the need to ever query the...

to find notes select * from notes where [text] = 'notes' but how do i find no't'es I tried select * from notes where [text] = 'no't'es' 0 hits I tried select * from notes where [text] = "no't'es" 0 hits I know the value exists so I must have the query wrong

I am planning a script basically using sp_revokedbaccess...to drop a lot of db user accounts. I think i can drop their logins afterwards with sp_revokelogin...however I don't want to drop any logins that still have valid DB user mappings. Is there a way I can check this before attempting?