Resolved.

Permissiion issue only.

Thanks to all

I am not sending any data or code here

I just need to know the error fix. Thanks!

One of the table is corrupt and I could not find SQL 6.5 command to fix it.

Not sure if an index or data issue

Error messages

Msg 624, Level 20,...

Thanks.

How can I mask uniqueidentifier datatype column?

error:

Msg 8169, Level 16, State 2, Line 2

Conversion failed when converting from a character string to uniqueidentifier.

columns names are different.

for ex:

Table 1

Column22, Column 25

Table 2

COlumn 4, Column 12, Column 23, Column 30

Table...

John Mitchell-245523 (2/15/2012)

---

I've never used this before, but this snippet from the ALTER TABLE documentation suggests you can drop more than one column at once:

| DROP

...

Thanks for your reply.

11/24 7:24:40 AM system shutdown unexpectedly due to power outage.

11/24 10:43 OS started

11/24 11:43 :58 AM sql server started

As per my understanding since all the committed transactions...

Thanks Kennath!

question: we have some 300+ tables in production server. lets say we identified 100 tables for data extract. do I need to add 100 oledb source's and 100 oledb...

9 tables - 9 pipe delimited file, separate for each table

task is completed.

Below are the steps I did.

1. create a empty database in SQL Server 2008 SP2 server.

2. copy only schema from SQL 2008 R2 version database to SQL 2008SP2...

Thanks!

buy my SQL Server 2008 R2 backup file size is 2 GB.

I am not able to generate script/export with data in one time.

I am thinking..

created schema script and execute in...

Welsh Corgi (8/12/2011)

---

If you right click on the database from SSMS and Select , Select the objects that you want to transfer and Export Data and run the wizard to...

Welsh Corgi (8/12/2011)

---

laddu4700 (8/12/2011)

---

Hi,

I tried to restore sql server 2008 R2 database backup file in sql server 2008 sp2 server, but it failed with error.

"The database was backed up on...

--table defination

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[LoginHistory](

[LoginID] [bigint] NOT NULL,

[LoginHistoryID] [smallint] NOT NULL,

[LoginHistoryDateTime] [datetime] NOT NULL,

PRIMARY KEY CLUSTERED

(

[LoginID] ASC,

[LoginHistoryID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,...

here is sample data in ready to use in format- attached