Scripting out your SQL Server 2000 objects is useful in any number of ways. You can save off the scripts for version control, generate the scripts needed to migrate to new hardware or a new environment, or just package up your application for deployment. Jon Reade brings us a look at the SCPTXFR utility, which can prove very valuable in managing your scripts.
2006-10-13 (first published: 2005-04-14)
38,791 reads
2005-05-04
1,435 reads
2005-04-29
1,255 reads
2005-04-21
1,528 reads
Many of us have SQL Servers at work that we learn on, test with work, etc. But getting your own SQL Server for a website can be a tricky thing. Especially on a budget. Or maybe your company wants to have their website hosted. Before you spend any hard earned money, read part 2 of this two part series by Jon Reade on what to look for when setting up a SQL Server hosting company.
2005-04-20
5,362 reads
Many of us have SQL Servers at work that we learn on, test with work, etc. But getting your own SQL Server for a website can be a tricky thing. Especially on a budget. Or maybe your company wants to have their website hosted. Before you spend any hard earned money, read this two part series by Jon Reade on what to look for when setting up a SQL Server hosting company.
2005-04-19
6,160 reads
2005-04-15
1,499 reads
The next version of SQL Server due in 2005 will bring about many changes in how it works, with .NET, the CLR integration, Integration Services, and much more. Many of us are looking to get a jump on the product and see where these changes might affect our scripts and environments. Jon Reade has started the work in decoding the new DBCC commands, which ones work and which don't. Since there's a limited amount of documentation for the Beta product, read about his detective work and send him off an
2004-12-16
34,245 reads
In this quick article by Jon Reade, he shows you how to correct an unusual error in SQL Server that may occur when you create a database.
2003-03-12
5,598 reads
By Steve Jones
I published an article today on the Data API Builder, which is a way...
By Steve Jones
dolonia – n. a state of unease prompted by people who seem to like...
By James Serra
Microsoft Fabric is rapidly gaining popularity as a unified data platform, leveraging OneLake as...
Hi Gents, Silly question, but it's been a long time since I've done this....
Hi everyone I have a query that is taking a real long time. It...
Comments posted to this topic are about the item The New Log File
I have a detached database from SQL Server 2019, called TDE_Primer. This database had a 100MB data file and a 73MB log file. The log file was lost, so I need to run this code:
USE [master] GO CREATE DATABASE [TDE_Primer] ON ( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\TDE_Primer.mdf' ) FOR ATTACH_REBUILD_LOG GOHow big is the new log file? See possible answers