Yes - that is a real problem - they are happy to "snatch" the free code from the open source projects but don't give anything back - ironically they are...

Yeah - altering a table with a million records through the GUI = brave man

Jeroen van der Wal (10/23/2007)

---

We are also in a build/buy debate but now considering the option where we take an Open Source ERP framework (Ofbiz) and customize it to our...

It is good to have the option on to generate scripts anyway (however much you like/dislike the SQL produced) - as this reminds you that you should have scripted!

Pity the...

As others have said issue is the varchar comparison - I would use something like

select 1 where getdate() <= convert(datetime,convert(varchar(10),'01/01/2008',103),103)

Create linked server with sproc sp_addlinkedserver - also you may need to create linked server login using sp_addlinkedsrvlogin see SQL docs for info on both of these.

Then to assuming your...

I would love the ability to have alias names for both servers and databases - it would make setting up test environments so much easier and also make the migration...

I work for a client where they are looking at doing something similar. The great thing about VM's is you can get one up and running real fast once the...

I think your confusion is on the version info - this is giving you the info of the SQL Server version/sp and the OS version/sp

The bit in "Microsoft SQL...

Aprat from other suggestions make sure you have not got AutoShrink on - I have seen this get locked up when doing massive operations.

Remember that data is stored in the...

As has been hinted at in other posts the performance depends a lot on whether or not the index you are (re)creating is clustered or not. In simple terms a...

Looking atthe error you are hitting it is actually the log on tempdb that is filling - and there is generally not much point in transaction logs on tempdb beyond...

Possibly easier to remember for column names in tables is to use the INFORMATION_SCHEMA views SQL sets up for ADO i.e.:

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE '%yourname%'

Adjust SELECT *...

Simplest thing I have found is detach the database files on the first server, copy them to the second (if v. big then copying first to some sort of NTFS...

DTSBackup2000 is the one for me - as it also allows you to save away copies of the jobs in its own format that preserves layout etc (not on any...