You likely will need to test data against SQL Server 2008 and SQL Server 2005, but ordinary backups are incompatible. Use SQL Server 2008's Generate SQL Server Scripts Wizard to push your SQL Server 2008 data back into SQL Server 2005.
2009-01-26
4,000 reads
With the start of a new year, Steve Jones gets back to the car updates with a look at winter driving and changes in the car industry.
2009-01-26
477 reads
With the start of a new year, Steve Jones gets back to the car updates with a look at winter driving and changes in the car industry.
2009-01-26
474 reads
With the start of a new year, Steve Jones gets back to the car updates with a look at winter driving and changes in the car industry.
2009-01-26
757 reads
Access can offer a lot of help with missing values, but finding and generating missing values in a field of sequential values requires a bit of code. Find it here.
2009-01-23
1,912 reads
Continuing the conversation I began in Part 1 & Part 2, today I want to ruminate some more on networking. I've had a good discussions about networking since I wrote the first two parts, with a focus on the value of networking.
2009-01-23
1,698 reads
Logging and recovery are critical parts of SQL Server, but they are often poorly understood. Paul Randal gives an overview of how the logging and recovery features work in SQL Server and explains the transaction log and recovery models to help you maintain a better database.
2009-01-23
3,187 reads
In this SQL School Video, Brian Knight shows how to abstract your schema with views and synonyms.
2009-01-22
4,417 reads
Had a bit of an oddity show up during some testing today when trying to disable log shipping on the primary server using SSMS. My test scenario was such that our secondary server was not available any longer (had been renamed) and when I tried to disable the log shipping...
2009-01-22
1,294 reads
2009-01-22
848 reads
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Comments posted to this topic are about the item SSRS Is Dead. Here Are...
Comments posted to this topic are about the item The Distance Metric
Comments posted to this topic are about the item The New Wave of Security...
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers