Did you create a computed column as GSquared indicated? You can't have an identity that is a character. You have an integer identity and then you have a computed column...

xp_regread?

Query the registry.

I still think he was creating a new word. Like "upgradation"

The question was edited to include an ORDER BY. Questions get edited if mistakes are found.

[drive by post]

Well maybe the questions aren't worse, but the grammar certainly is!

"The problem is that the order by clause was left out on the initail page."

[/drive by post]

blandry (5/29/2009)

---

If I get the salary like an athlete, does that mean that I have to...

- Immediately start using steroids?

- Open up a pit bull fighting arena in my backyard?

-...

Edited the title. Please don't use tags in the titles.

Are you not backing up data? Or are you just trying to get schema data?

You can let people onto the publisher after you've enabled replication, and if the subscriber isn't available, you are correct, the distribution db/log grow until they can get to the...

I used to deploy changes like this using osql and a batch file. Now I'd use SQLCMD. The SQL Server install runs .sql files for some things using SQLCMD

Interesting. I thought most people would be against it.

For professional atheletes, it's a dog eat dog world, and they often go down as well as up. It just isn't reported...

sayfrend,

Thanks for the license update. That must be a change from previously.

I think Google is just as bad as Microsoft has been, but I also think that this is the way most companies behave as they get successful. People want to...

I tend to agree with Jefferey here, but I'd say that you want to standardize so everyone knows in a DR situation which data to restore.

If there is non-SQL data...

You'd need to log from the plan, not the job. The job doesn't log enough.

The big thing with remote backups is that any hiccup in the network will fail it....