Viewing 15 posts - 3,826 through 3,840 (of 9,712 total)
Actually, I have a few thoughts that could get around this. Mainly via the use of a subquery that selects each distinct property and then JOINs to the other tables...
November 28, 2012 at 5:48 am
Just because SCCM requires windows authentication doesn't mean that you have to alter your SQL Server authentication settings. You just need to make sure security in the database is set...
November 28, 2012 at 5:45 am
Do you have Auto_Close enabled on your SQL Server properties?
That's the first thing I would check. If not, then I would get a network sniffer running while you try to...
November 28, 2012 at 5:41 am
Unless I'm misreading this, the buffer pool doesn't come from SQL Server's allocated memory.
BOL says
November 28, 2012 at 5:37 am
You can search stored procedure definitions by joining sys.objects to sql_modules and doing a WHERE clause with a LIKE statement on the definition column of sql_modules. That should locate all...
November 28, 2012 at 5:30 am
I don't use FULL TEXT, but this isn't the first time I've heard of this sort of issue. Could you post some DDL, sample data, and the querying code you've...
November 28, 2012 at 5:29 am
TealCanady (11/26/2012)
I don't know the alert code you're using ....
Teal, I attached the code I'm using as a text file to my first post in this thread. It's hitting the...
November 28, 2012 at 5:25 am
capnhector (11/26/2012)
November 28, 2012 at 5:21 am
Jo Pattyn (11/27/2012)
DBCC Timewarp: Active Directory returns to 19 november 2000.
The interesting thing about this article is the following line:
The forest root PDC or master time servers in the forest...
November 28, 2012 at 4:52 am
Grant Fritchey (11/27/2012)
jcrawf02 (11/27/2012)
Okay, so looking at the new ads from redgate on the site, and thinking Steve is obviously Hannibal, which makes Grant...Mr. T?
No, no, no. I am the...
November 27, 2012 at 8:55 am
SQL Server doesn't track those things. Therefore, no, there is no T-SQL command capable of getting that information.
However, you could use PowerShell or xp_cmdshell to get out to a command...
November 26, 2012 at 5:29 am
sunilmadkar 86235,
Try reading the most recent replies to this thread. They contain good advice.
November 26, 2012 at 5:09 am
Koen Verbeeck (11/9/2012)
The Dixie Flatline (11/9/2012)
Hey, does anyone realize that in 8-9 days, The Thread will have been running strong for 4 consecutive years now?Will there be cake?
There should at...
November 9, 2012 at 6:10 am
Koen Verbeeck (11/7/2012)
Lee Crain (11/7/2012)
"Can you tell...
November 8, 2012 at 4:09 am
Viewing 15 posts - 3,826 through 3,840 (of 9,712 total)