EM is doing your legwork for you. by the time you create and debug a script to move the tables, you can have it done in EM. take...

You get what you payfor. MySQL is a great learning tool. Industrial strength solutions require industrial strength tools. You have to have things like backup, multiple queries,...

Timestamp is not really an indicator of time in SQL Server. If you want 2 datetime fields, use that instead.

Timestamp is a database-wide unique number.

The lesson here is that NULL and DEFAULT should be trigger that you have an invalid table definition. If you are supplying a default, then the column should be...

Are you sure your 1st job is finished before you try to run it a second time? And make sure the job is enabled.

quote:

---

Even then when a stored procedure is run you cannot concatenate two vairables to a single parameter. Even if both where 4000...

You need to supply more detail about what's failing.

In EM, you can get this if you are trying to update rows from a complex view that doesn't include a...

SQL doesn't have "variable length rows" so you need to return something for each column. Use

select ColumnA=isNull(columnA, '') and specify every column and an appropriate default value. If...

Antares solution will work. however, this function is better served by your client app that inserts the data. names are notoriously inconsistent in particular when you start with...

The backup is always performed by the server itself. You can make a backup of the .ldf and .mdf files if you want a "sorta" backup from another machine.

if...

quote:

---

Is there a way to automatically add/suppress leading zeros in a numeric column? Any help would be greatly appreciated. Thanks.

---