If I understand you correct you ask if you can install SQL Server 64-bit on a 32bit OS. That's not possible.

While you can install a SQL 32-bit version on...

amarbreddy21 (2/11/2009)

---

Markus:

SQL Server records the first and last log sequence number (LSN) which is included in a backup

This LSN is stored only for backing up transaction logs r does...

SQL Server records the first and last log sequence number (LSN) which is included in a backup. This information is stored in the msdb databases in the backupset table.

This article...

Use a height value of 0 for interactivesize.

Oops, I didn't see that this was posted under SSIS. But I think you could still call sqlcmd using the Exec Process Task in SSIS.

But probably the better approach would...

The page size can be set in two ways. First select your report and show properties. Under LAyout you can define the size of a page.

For the HTML reports you...

You can either simply declare the variables in you script and then SET the values or you can use sqlcmd.exe with variables

Save your query as yourscript.sql like this:

select field1, field2,...

Alexander,

if you transfer your logins including the SID, you won't need to use 'sp_change_users_login'. This procedure is usefull if you create a login with the same name like on...

I just wonder, depending on the properties you're looking for can't you just query master.sys.databases?

It contains a column for almost any database property, incl compatibility level.

Another approach would be using...

Yes you can install 3.5 on...

I think the errormessage is pretty clear. The owner of the job cannot be verified. Either the windows login has been removed or the server couldn't contact AD to verify...

There is no hard limit for the number of rows. Like BOL says it's only limited by the available storage space.

If you should partitition your table or not is depending...

Rudy,

I did experience the same on one server. Not 100% sure if it was the same error but I think it was. In my case a simple refresh did...

Don't forget to move your logins, jobs, alerts and operators. You can do these either through scripts or using SSIS.

Do you want to eliminate duplicates or do you just want to append all records from one table to the other?

In the second case just do:

INSERT INTO TABLE1

SELECT * FROM...