SQL Server 2005 (script produced trought management studio):

table SGTALIQDATA:

USE [SGT]

GO

/****** Object: Table [dbo].[SGTALIQDATA] Script Date: 08/14/2009 13:59:52 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[SGTALIQDATA](

[CODLIQ]...

what do you mean with tables definitions?

The field names and data types?

thank you

yap, it works.

But i have a problem:

I do this comand:

exec master..xp_cmdshell 'bcp "select * from database..table order by field1" queryout "c:\excel\1.xls" -c -T -S "Servername\sql2000"'

This command creates the excel file.

What...

If you really what SQL 2000 knowlage, than a good book to read is SQL Server 2000 bible.

P.s Gail Shaw is right , why don't you start in SQL Server...

In my case, what i really would like to know is, if there are any differences (in terms of funcionalities) between ESX and hyperV.

For instance, i know that with ESX,...

can someone help me , please?

I'm realy don't know how to fix this

Hi masters,

I have now putted the code as below and i noticed that when the

code is executed and there is no Excel file yet, it gives me...

what are the advantages over hyper-v?

thank you very much,

I have tried to implement the model, but i have a problem.

Please, look at my script , to see what i mean:

-- Create...

yes, in SQL Server 2000 database i did not update statistics in the 2005 database i have updated the statistics

ok, thank you for the reply.

I would like to know in production, what dbas are using?

thank you,

Pedro

what are UAT implementations?

Hi Gail,

Thank you very much.

I was wrong.

I tested again, and it works.

sorry for the wrong information.

thank you all, for reply to this post

yap, that's an easy way.

I don't know if you can go to the Management/activity monitor and Kill the connection that is connected to that database and then you trie to...

Hi,

When a database is in Single_user_mode, if there are no connections , you can connect to it.

The first connection to gain access will be the only...