my databases are already in simple mode

i was able to install 64 bit and 32 bit of ace drivers on the 64 bit machine.but 32 bit gave me only one error messager. where as 64 bit...

which version of the driver should i use on 64 bit machine.

I see both 32 bit and 64 bit for ace

I am not doing any transactional log backups in my environment

when you do that you have to do for each database separately.I know to do that but i need an alert which checks the 70% space for all of the...

I have SQL Server 2008 R2 enterprise edition.on windows server 2008 enterprise 64 bit

I can create table variable in this format

DECLARE @DBuser_sql VARCHAR(4000)

DECLARE @Schema_table TABLE (DBName VARCHAR(200), UserName VARCHAR(250), LoginType VARCHAR(500), AssociatedRole VARCHAR(200))

SET @DBuser_sql='SELECT ''?'' AS DBName,a.name AS Name,a.type_desc AS LoginType,USER_NAME(b.role_principal_id) AS AssociatedRole...

You cannot vote on your own post

0

I am sorry my post was not clear to you. let me be more elaborative

TABLE A values

Name ...

I did not create any foreign keys between the tables

yes i can use table variables and i can insert into the table variables from the tsql statements

TABLE A values ...

I changed the location to G: and it is working now.

Thank You

i am using sql server 2008 r2 enterprise edition

sql server agent is off already. it is not running

I used both.First I tried sqlcmd and then I tried ssms