you posted in SQL2000, so be aware that if you meant 2008 or above, the ACE drivers would b eused instead.

typically, you will create a linked server, and reference...

take a look at this post i participated in a while back; it's got some handy code for finding all invalid objects, which would happen on procs/functions/views if the underlying...

i'd say it's a bad trigger.

it does not handle multiple rows at all.

there may be a logic hole here as well: it updates the entire contact2 table for any row...

seven columns in the table, only six in the query;

your table has the column name Logintime , but your query does not.

the implied column list, for when you say...

Mani-584606 (12/17/2013)

---

Thanks Keith,

The script is giving database level permissions. I'm looking entire instance level.

For example the user has read on one database and write on another database and has view...

you cannot rename an instance.

that means, for example, if you installed machinename\SQLEXPRESS, and you want to rename it to be machinename\SQL2008R2 that is not possible. you have to backup whatever...

renaming a server is a two part process;

one occurs at the operating system; the second is for convenience in SQl server.

You rename the server and then reboot.

AFTER that has occurred,...

scripting from the GUI, whether create or alter, will contain the same definition, but the GUI adds

this like SET ANSI_NULLS ON and other settings; potentially the USE [database] statement as...

well answers to questions for an Ingres database will hopefully conform closely with TSQL answers you get here.

the question is not really clear to me; when you run your max...

Minnu (12/17/2013)

---

Hi,

Thank you for Speedy response.

my question is, when i print the values from trigger

print @id

print @name

Print '--'

am getting

1

D

--

but as per my table id's 1 and 2 are updting,...

i'm thinking that your user is in a windows group that grants them permissions you didn't expect.

this query seems to get all the individual mappings for all the groups i...

yeah syntax is important here;

you already identified that you know the a trigger should refer to the virtual inserted or deleted tables;

the key is that the original table needs to...

defyant_2004 (12/16/2013)

---

We really want to protect the server and limit the amount of unnecessary access. Although I am not an expert at DBA work, I have used SSMS in...

defyant_2004 (12/16/2013)

---

We just installed a couple of SQL Server Express editions with a few standard databases.

Our DBAs are insisting that SQL Server Express does NOT provide the necessary tools to...

As a DBA, the #1 reason (for me) I seem to need access to the server itself are for diagnosing ETL issues and managing of SSIS packages;

we have a...