As a quick and dirty fix (assuming this is a one time data load), you can set the data cells in the column to Text in the .XLS file, forcing...

Karthik,

If you can provide the Version of SQL Server and Sybase, I can get more specific.

I found a walkthrough for "Configuring a Microsoft SQL Server Linked Server with Sybase ASE...

Too Funny!

sqldumbass.com is getting hit when I get home tonight.

I also have the SQL Shirt from thinkgeek.com. I tend to wear it to disaster recovery sessions (the drills, not...

Evan,

We too have an AS/400 and SQL 2005 environment.

You have two options, depending on what version of SQL Server 2005 you have.

SQL Server 2005 Standard Edition:

2 step connection process ...

We...

Peter,

Can you give us a little more information to work with?

How is the report being generated and delivered to each computer?

Is there another notebook/laptop that is getting the report without...

Vladan,

I am happy to report that I am now getting the run_duration back in seconds, after scripting the Restore operation to a Job. Thanks again for the suggestion and...

Vladan,

Your technique is exactly what I was looking for. I will work on getting my restore job created, and will post back with results. Thanks for taking the...

Starting the Maintenance Plan Wizard >>

Give a name and Description >>

Give a single schedule, as I assume this will be a single task. >>

Choose "Clean Up History" maintenance Task >>

(Cleanup...

Mike,

Are you searching through just one table of columns, or an entire database of tables and the columns within the tables?

If you give us more information on how broad a...

Remote connections in SQL Server 2005 are disabled by default.

You will need to change or verify your settings in the "Surface Area Configuration for Services and Connections" application.

Start >>

All Programs...

Due to the nature of the system databases, there are extra steps involved in moving them.

--

The following Microsoft Knowledge Base Article will work for SQL 7.0, 2000, and 2005 respectively.

How...

hb,

With our vendor supported applications that we are not able to get an ERD from, I use Visio Professional 2007 for reverse engineering a database.

I wrote a tutorial in another...

In my experience, most companies DO have ERD diagrams/documentation for their database applications, but that information can be considered proprietary information and is not generally given to customers.

Another possibility is...

I have written weekly jobs with the following break down at the instance level:

Sunday 9:00 AM: Reorganize Indexes

Sunday 11:00 AM: Rebuild Statistics

Sunday 5:00 PM: DBCC CHECKDB

Daily 6:30 PM: Backup...

b_boy,

Hopefully my notes will get you started, there is a LOT of work involved in modeling. I personally view it as an art form.

--

If lines are drawn between objects...