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...

I think you'd just extend the WHERE statements in the query to also compare the @RoleId :

how about this?

and g.ID in

(Select ID From Groups

...

5.5.1 implies you did not set up your db mail to send the basic authentication to have the username and password:

jeganbenitto.francis (12/16/2013)

---

Can Anyone please help me in below requirement

i have a row as below

1 AAAA BBBB CCCC DDDD EEEE FFFF GGGG HHHH

I...

whoops i cross posted from anotehr post;

can you show us /script out your linked server?

that would help us diagnose the issue for you.

look at the stored procedure in question...i'd bet it is referencing a linked server. the login is failing at the linked server because whoever is calling it doesn't have mapped...