Viewing 15 posts - 3,826 through 3,840 (of 9,715 total)
jcrawf02 (11/28/2012)
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...
November 28, 2012 at 6:16 am
We need your table DDL (CREATE TABLE statements) and some sample data to test with, please.
November 28, 2012 at 6:03 am
ssarria (11/28/2012)
Hey Pavan,some how is not working, it is giving me an error messages. It is a syntax error... sorry I am still learning SQL..
Thanks!
S
Please post all your code and...
November 28, 2012 at 5:50 am
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
Viewing 15 posts - 3,826 through 3,840 (of 9,715 total)