The IDENTITY property and the column it's attached to are inseparable, which means that you can't add or remove IDENTITY from an existing column.You can use workarounds, but these can...

Why don't you try by specifying the same 'sa' password tht worked with first named installation and change it later.

MJ

I think yes.

http://www.sqlservercentral.com/articles/SQL+Server+2008/63491/

MJ

For object level permissions, replace testing with the username you want to script out permissions:-

SET NOCOUNT ON

-- declare all variables

DECLARE @DBName SYSNAME

DECLARE @sql nvarchar(max)

DECLARE @sSQL1 Varchar(30)

DECLARE @iRowCount ...

Use the below mentioned stored procedure and replace test2 with the required loginname.

Create PROC usp_sql_audit

AS

SET NOCOUNT ON

IF EXISTS (SELECT * FROM tempdb.dbo.sysobjects WHERE name = '##Users' AND type in (N'U'))

DROP...

There is no such useful table. However, you can use profiler to track the activity against sql server database and then make an conclusion as to which procedures were never...

select * from sys.columns

where name=''

go

select * from information_schema.columns

where column_name=''

MJ

From BOL:

Point-in-time recovery is not supported with the Bulk-Logged Recovery model. Bulk-Logged recovery only allows the database to be recovered to the end of a transaction log backup when the...

Change condition to where Table Name = Upper(Name) and then evaluate the policy against your database.

MJ

sunny Brook (1/2/2009)

---

You need to Split the range...twice.

1. add 1 new filegroups

2. add a file to the filegroup

3. Alter your partition scheme to include the added new...

No problem with that but as a best practice try not to shrink databases.

MJ

I don't think its possible using sql server native tables. Third party utilities might help here.

MJ

From books online:

ON { | filegroup | "default" }

Specifies the partition scheme or filegroup on which the table is stored. If . If filegroup is specified,...

I suspect it has something to do with FAST switch used here.

FAST

Specifies whether to perform a fast scan of the index and output minimal information. A fast scan does...

I created one test login and granted no other permission except default one. After that I ran your code and it ran perfectly fine.

Microsoft SQL Server 2005 - 9.00.3042.00

MJ