I think my take on it would be similar to many of the questions on the forums, outline one or more problems, construct a table structure relevant to the problem(s),...

Janrith (9/9/2015)

---

Greetings,

I've recently inherited a slew of databases and many of the table population stored procedures seem to have a common methodology:

Truncate Table TableA

Set @count = (select count(*) from TableA)

While...

Sweetbee870 (9/9/2015)

---

Okay this is what I'm running:

Select FirstName, LastName, Title

from Employees

See attached the Results. I need know how to only retrieve records for "Sales Representatives"

Hope this is...

Quick thought, the first hard limit is the maximum number of user connection is (2^15)-1 or 32,767, configurable, use SELECT @@MAX_CONNECTIONS to view the current. Memory consumption of the connection:...

Glossy

GilaMonster (9/9/2015)

---

Because doing so would prevent him from logging in entirely, whereas the trigger prevents him from...

Phil, not going into the begininator/terminator debate 😀 as this is a habit for the convenience of...

ramezani583 21209 (9/9/2015)

---

Hi all,

In the Operating environment databases, may be made tables in the database on a temporary basis but they are still yet and they are not removed, how...

dan-572483 (9/8/2015)

---

Is there a command that will list the user members of a Database Role, as opposed to right-clicking the Database Role/Properties, which doesn't allow you to sort the members...

shamshad.ali (9/8/2015)

---

I use following trigger to stop user "smith" if he try to connect through SSMS to My Server:

create TRIGGER [trg_connection_MyServer]

ON ALL SERVER WITH EXECUTE AS 'Smith'

FOR LOGON

AS

BEGIN

IF ORIGINAL_LOGIN()= 'Smith'...

Run DBCC CheckDB ('[db_name]') WITH NO_INFOMSGS, ALL_ERRORMSGS and post the full unedited output.

😎

BTW, how much free disk space does the server have?

ilovedata (9/1/2015)

---

I am using an Adventure works Cube with DimEmployee dimension. When I look at the data through browser, I can see as below.

-->All

---->Ken, Sanchez

------->Laura, Norman

------->Debbie, Borah

---------->Shawn, Mike

---------->Lacey, Rhonda

Now I...

Quick questions, why use Lock Pages in Memory? Is there anything else running on the server, i.e. SSAS, SSIS or SSRS?

😎

Have a look at these two articles

- Lock...

karen.blake (9/7/2015)

---

Hi All,

Will try and explain this better.

We have a SAL field in the database that has numeric and alpha and just alpha data in it.

I need to get a...

Quick thought, according to the log the server is listening on TCP 1433 and 1434(DAC) but no mentioning of UDP 1434, is the Browser Service running?

😎