Developer Newsgroups: SQL Server Tools

sys.dm_db_index_usage_stats

Michael DeVoe NA Navision Support - 4 Aug 2006 5:49 PM - 2 messages

SQL2005 SP1 Dev edition I know I am just not understanding this correctly. When I run the DMV sys.dm_db_index_usage_stats the database_id column seems to be wrong or do not line up with sys.databases. The object ID's reported for database_id 4 ...

Can you apply functions while loading data?

Dwayne King - 4 Aug 2006 12:24 PM - 2 messages

HI there, I'm interested in whether or not BCP can apply to functions to data while loading. For example, I am loading source data that has several decimal places (more than is defined in the table). Currently (with MSSQL 2000) the decimals are ...

SQL 2000 Database corrupt

Laurent - 2 Aug 2006 3:55 PM - 6 messages

My server contains severals databases. All query returns a response. But performance are very low when my query "links" 2 databases with a "inner join". So I create a new base, copied data on this base and all is all right. ...

Always wants to Recover Selected Files

jhcorey - 2 Aug 2006 1:03 PM - 1 message

Every time I open SS Management Studio a dialog says it was not shut down correctly (it was) and offers to 'Recover Selected Files' which I had alledgedly been working on at the time. Anybody know I quick way to stop this behavior? ...

Database Mail encoding

Niclas - 1 Aug 2006 12:11 PM - 1 message

I am sending e-mail messages with Database Mail in SQL-server 2005. The e-mails are not correctly displayed in some e-mail clients. The problem is unicode characters. It works when I send the mail from my vb.NET code and ...

A Question on Inserting a column in SQL

balaji.balaraman - 1 Aug 2006 2:49 AM - 3 messages

Hello everyone... I wud claim my knowledge of sql anywhere between novice to intermediate. This is what I'm trying to do... Table Name: demo As is: Date Batch No Part No ...

What is equivalent command scptxfr.exe in SQL 2005?

chatakondu - 31 Jul 2006 8:28 PM - 2 messages

What is equivalent command scptxfr.exe in SQL 2005? I have been reading groups that, this is achieved with SMO. If that is the case can anyone point me to exact location of example. I need to script the whole database. ...

Getting data from sp_trace_getdata SP

Prasad - 31 Jul 2006 9:46 AM - 4 messages

Hi, I want to get data from the sp_Trace_getdata SP in SQL Server 2005, but if I pass "1" as the second argument I get only 1 event and all the events after that are cleared. Secondly if I use the "0" as the second argument the SP returns only ...

LISTEN TO SEXY FREE NOW

mediapuri - 30 Jul 2006 12:42 PM - 1 message

English / Chinese / Franch / Germany / Japan / More World Largest, LIMITED TIME FREE TO LISTEN!!! 24-Hrs +91 9810577227 ...

Copy db to webhost server

Jonas - 30 Jul 2006 12:31 PM - 5 messages

Hi, Is there any way to use Management Studio to copy a database from my local SQL2005 server to the webhost's? Back up/restore or Copy Database requires root access, which of course I don't have on the webhost's server. ...

SEX HOT LINE FREE TRIAL!

TCI SM - 30 Jul 2006 12:27 PM - 1 message

English / Chinese / Franch / Germany / Japan / More World Largest, LIMITED TIME FREE TO LISTEN!!! 24-Hrs +91 9810577227 ...

Buy 2nd handphone for India market

i - 30 Jul 2006 12:15 PM - 1 message

Highest rate for all type / brand 24-Hrs +91 9810577227 Puri ...