Thanks Scott, "Sync with Table of Contents" is what is needed . 

Here is my WHERE clause :

where

(isnumeric(substring(data,1,8))=1)

and (convert(int, substring(data,1,8))...

No, this button is not the same as Locate. When I am in the right pane , by pressing Contents button it brings me to the general title SQL Server...

Also Database Diagrammer which is part of SQL Srever 2005 SSMS. It does not have logical design layer, but for reverse engineering it's quite good.

It's interesting thing.

But when I ran it I got a message:

Msg 7403, Level 16, State 1, Line 1

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.

How to...

That's good article, but they don't answer to my question what type of wait is CXPACKET.

My server is running on Windows NT 5.2, or it is the same as Windows Server 2003 ?

Here is full output of my @@version:

Microsoft SQL Server 2005 -...

Another way to do it:

1. Copy your Excel data into text file - it will come as tab-delimited file.

2. Create target table in SQL Server.

3. Run BCP IN in DOS prompt,...

Thanks Steve, I see you started brand new forum in responce to my question.

I actually intended mostly to read rather than write, I am going on series of interviews...

It's a number. For example 101 means 1 min 1 sec.

Thanks Markus, This is good script. I will use it in our environment.

Thanks Brandie, I asked him but he has no idea about that.

Yes, that's right, SharePoint is using SQL Server database for its storage. But the problem is that SharePoint hides its SQL Server server name and other connection properties like database...

Thanks Yelena, this is good, I did not know about this.

Thanks

You can also use exec master.dbo.xp_cmdshell 'type c:\filename.txt' .

If you want to save...