Many thanks for your response, but I know that it should be possible; My issue is that they are not working and I wanted to know from someone who has...

Akayisi (2/18/2014)

---

Hi guys I am testing users' rights in sql server. However; I would like to add another column to sys.server_permissions which describes the name of endpoints. For instance;

I connect...

With Standard Edition you are limited with your choices but, you could run a server-side trace for just their ntusername. That would span across all databases or just a...

Looks like you need an OUTPUT parameter

CREATE PROC USP_first @id INT OUTPUT

AS

DECLARE @date AS DATETIME

SET @date = GETDATE()

SET...

Sounds like it could be permissions based. Are you a sysadmin on the SQL server?

Either way;check the sql log files and/or event logs for the reason that the service...

You could look into utilising resource governor (built into SQL) for this very situation

🙂

The DR is not for the same server - It's a warm standby of another server but always worth mentioning for others reading the post. It wouldn't really meet the...

Thanks for the response Brandie - The named instance is to be used as a warm standby for DR, so there is no real performance concerns as the default instance...

chewychewy (8/14/2013)

---

Hi Guys,

Understand that by default, SELECT statement on a table will block update statement on the table.

By setting READ_COMMITTED_SNAPSHOT, update statement (writer) will not block select statement (reader) as...

mohan.bndr (8/14/2013)

---

Can we assign port 1433 to a named instance ? I know that these 1433 as port number to default instance. Please clarify, Can we allocate port 1433 to...

Sean Lange (8/16/2013)

---

They would if either of the tables has only 1 row....

I would also look at securing your database with the relevant lowest possible priviledge. Having correct security from the outset can reduce the chances that someone will delete data directly...

Thanks for the response

If you are using this column to hold financial data I would not recommend using float, as it is an approximate data type. Use decimal instead.

Hi Gail - Hope you are well.

I spoke to you at SQL in the City In London a week or so ago (i was the one with the questions...