You're wanting to retrieve a value that you're not actually storing anywhere?

Or do you mean that you want to return whatever the current timestamp is at the time of insertion?...

SQL Server 2008 databases are not backwardly compatible with earlier versions. Assuming you haven't used any 2008-only features, you should script out the entire database structure, and use the...

Note that from a security standpoint you shouldn't use encryption to encrypt passwords, as if you know how to decode the password, then you can apply the same logic to...

It's not something I've tested in a while, but it's likely that SQL Server will remain high until the buffer pool drops below the 6.5 GB mark, and then won't...

Great Plains: http://www.microsoft.com/dynamics/en/us/products/gp-overview.aspx

Personally, ERP packages don't excite me, but that's probably why the people that work with them get so much money 🙂

My main reason is because it's a one-way operation. There's no way to go back to the previous case. If there is any possibility of requiring the data...

I think they key point is "consulting company". A typical consulting company will be more targeted towards larger clients, and thus focussing on BI-type projects. The clients will...

alen teplitsky (7/8/2010)

---

my memory is not as good as it used to be, but i don't think you can do it using dynamic SQL. i think i tried this one...

You'd definitely want to compare like-for-like. I recommend installing 2005 on a dev workstation and seeing how the database performs there.

As an example, in SQL Server 2005, UDFs were...

The OVER SQL Construct or statment is not supported.

Ok so reporting services can not deal with the ROW_NUMBER function no big deal I will just place the query in a...

The transactions held inside the stored procedures should not matter unless they rollback. Each time you start a transaction, your @@TRANCOUNT increases. The transaction will only be committed...

To really maximise income and on-going work, I'd go for SQL DBA + Performance Tuning + Consulting/people skills. The "soft" people skills will always project you further than being...

From my experience (admittedly limited - just the past 8 weeks) with Commvault, it's very good at detecting when the log chain has been broken, and will take full backups...

In SQL Server 2005, the 2000 system tables changed to catalog views, and were not writeable.

This has nothing to do with the mssqlsystemresource database - this is a read only...

This is a tough question, for the simple reason that admins can do anything in a database. You've mentioned Query Analyzer by name - are you working with 2000,...