Ananth (11/19/2007)

---

Hi ,

I'm using sql server 2000. Do you have any query or site to view the solution. I need to generate the serial number in the query,so that the...

Hi Satish,

the very first thing that strikes me is that you are using unions. Are you sure you cannot get away with "union all"?

Regards,

Andras

SQL Server...

Dugi (11/18/2007)

---

Hello,

as I can see there are the understandalbe question and answers but can anyone explain to me about this part of SQL code

...

) on ps1(a)

...

(it is a Partition...

The database has been backed up into two files, you need both to restore the database. First make sure that the customer sends you both files, and then make sure...

Do you have something like this in mind?

CREATE TABLE mytable

( a INT IDENTITY

PRIMARY KEY

...

What you can do is to take more frequent transaction log backups, or (this is not a good approach, but depends on the requirements) switch to simple or bulk (if...

Sorry, I've just noticed that you would like to do this on 2000. My query would work on 2005. You can implement row_number() on 2000 (see http://support.microsoft.com/default.aspx?scid=KB;EN-US;q186133) but that is...

You should really really do this on your client. SQL queries return a sequence of rows (which should even be handled as sets or bags in most cases). The information...

Hi Berto,

There are some breaking changes in higher compatibility modes. For example SQL Server 2005 no longer accepts =*, and there are some new reserved keywords, e.g. "PIVOT"

You can read...

On 2005 to enable xp_cmdshell:

EXEC sp_configure 'show advanced options', 1

GO

RECONFIGURE

GO

EXEC sp_configure 'xp_cmdshell', 1

GO

RECONFIGURE

GO

Regards,

Andras

vadimt (11/14/2007)

---

my .ldf file has grown over 2 GB and i need to shrink it or clear it. or even delete completely.

is it possible?

thank you.

edit: i'm a developer using SQL...

If there is a duplicate row, and you only want to delete one of them (or only a certain number if there are more), then you can do something ugly...

I assume that this table does not have a primary key 🙂 (it is bad, but it is of course another story)

You could build a new table with only the...

Red Gate's SQL Compare is one (it compares database schemata, and generates the change script)....