The quick and dirty method is

SELECT * INTO NewTable FROM sourcetable

However, if the sourcetable is large then this may impact on your servers performance.

You can also right-click on the object in the object tree within SQL Query Analyser

The query optimiser may have detected that it needs to run a query in a different way and therefore has generated a new execution plan.

Have a look what tables are...

Don't forget Innovasys DocumentX. It covers SQL Server, Oracle, Access and also does .NET assemblies, Visual Studio projects, ActiveX and VBA.

After using a proper tool I wouldn't use a...

I'll be 40 in February and the past two years have been an eye opener.

I left a job that paid well, was within cycling distance of home and had colleagues...

If anyone is interested the SQL2000 equivalent is

USE Master
GO
CREATE PROC dbo.sp_DBA_spaceused_AllTables2
@updateusage varchar(5)='false'
AS
SET NOCOUNT ON

IF @updateusage IS NOT NULL
BEGIN
-- Allow for case sensitivity
SET @updateusage=LOWER(@updateusage)
IF @updateusage NOT IN ('true','false')
BEGIN
RAISERROR(15143,-1,-1,@updateusage)
RETURN(1)
END
END

-- Retrieve the current...

I seem to remember that there is a non-documented stored procedure that runs the resultset of a query.

In some situations I do build up a string of commands and then...

Thanks for the comments Andy and Jeff. I don't get too worried about criticisms, we are fortunate enough to live in a democracy and as Voltaire said.

I disapprove of...

What do you get when you cross a sheep with a bee?

Baa Hum Bug

I've got to put up a Christmas tree, swear at the lights, murder a few carols and fight with relatives, but I will give it a go after Christmas and...

In 192.168.2.10 the octets would be as follows

1. 192
2. 168
3. 2
4. 10

Would I be correct in thinking that by using the most changing octet SQL Server is most likely to think that the...

I don't think that there is any easy answer.

One of the examples in the "Update your development skills to SQL2005" course uses a CLR datatype to hold an IP address.

I...

Thanks, but the WHERE Oct_1 IN () clause doesn't really provide an easy solution.

I can't remember the specific IP address range for the Google ROBOT but similar exclusions look for...

Our data analysts wanted to build a model that excluded IP addresses in a pretty obscure range

The problem was coming up with a simple query that would work on...

The IP Address problem is one that I am facing.

When stored as a string it is a VARCHAR(15), it is human readable but difficult to do range searches.

When stored as...