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?

😎

algytaylor (9/7/2015)

---

Hello! This is my first post here 😀

PHP has been printing out the following error when I try to connect to SQLServer 2008 RC2:

Fatal error: Uncaught exception 'PDOException' with...

One can truly argue that science is probably the greatest invention but in the adoption of scientific methods in the software industry it has somehow gotten lost in translation. Hypothesis...

Quick question, can the SQL Server Agent access the Administrator's home directory?

😎

Suggest you read this article: Setting...

Piling on Andrew's and Ed's good answers: avoid using functions on the columns in the where clause if possible and all the alternatives forms of that, such as function in...

Quick suggestion, use N'' prefix, then the SQL Server automatically uses UTF-16

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.TABLE1') IS NOT NULL DROP TABLE dbo.TABLE1;

CREATE TABLE dbo.TABLE1

(

XXXX varchar(255) NULL

...

If you are trying to overwrite the existing database then use WITH REPLACE (options tab in the restore database...

Post the full configuration for the agent job.

😎