At the bottom of a forum listing, you can choose how to sort the entries and how many posts you want to see. I think the default is 'last...

If you are using SQL 7 or SQL 2000, you will need to create the index when no one will need to access the table.

If there will be hundreds of...

I have 6 SQL Servers with over 1000 databases. We are doing data mining basically. 52TB of data so we break up the databases into smaller pieces for...

MCSE - Minesweeper consultant, solitaire expert

MCSE - Minimal Computing Skills Expected

If you decide to use a prefix, then yes, usp versus sp makes a difference. SQL Server automatically searches the master database when sp_ is called. That can...

No, but I am hoping to go to a dirt bike school in March. I have heard it will help me ride my street bike better...and who knows, I...

Here in the US, my voucher came in the mail with my paper results.

You could run this in Query Analyzer. That gives you the option of making a CSV or Excel or just viewing in the results pane.

use database_name

go

sp_help view_name

I only took 070-431. My status showed up on the transcript site before I received the report in the mail.

I received my paper results yesterday(Feb 6, 2006) in the mail.

I have had some luck in importing this to Access first and then import the Access table into SQL. It is a pain.

Since you have street field in the data twice, that is probably where the duplicate column error is coming from. I suggest not marking the 'first row has column...

In order for Access to update a SQL table, all BIT fields must have a value and not allow nulls.

Thanks Darek! I checked the transcript site and it is posted this morning! I PASSED! Yipee...now, that is the way to start a Monday.

Microsoft MCP transcript site...

Has anyone received the results for the beta exam they took?