Viewing 15 posts - 3,226 through 3,240 (of 9,712 total)
The thing about ordering is that it never works quite the way you expect. The individual columns are all associated with one record, so you can't get every column to...
April 21, 2014 at 5:43 am
The column you are looking for is type_desc in sys.server_principals.
April 21, 2014 at 4:40 am
vignesh.ms (4/19/2014)
this is not the fine answer & also not mine...
You were not asked to post someone else's code. You were asked to post what you tried.
If you are unwilling...
April 21, 2014 at 4:34 am
Regarding the error... Are you sure that the accounts you are using have FULL CONTROL on the share where you're trying to create the subdirectories?
Definitely (just for kicks and giggles)...
April 21, 2014 at 4:28 am
J Livingston SQL (4/18/2014)
try this article........
AWESOME! Thanks for that link. Gail, as always, does wonderful work.
April 18, 2014 at 8:44 am
Perry Whittle (4/18/2014)
Brandie Tarvin (4/18/2014)
But none of us recommend you lower the max memory setting unless you know the consequences.
You would do if your server starts blue screening because...
April 18, 2014 at 7:23 am
vignesh.ms (4/18/2014)
Brandie Tarvin (4/18/2014)
This sounds like a contest or homework problem to me.Should be mixture of all products..
I'm eagerly waiting for the query....
Pls try it out..
Sorry. I don't do other...
April 18, 2014 at 6:55 am
If the error is happening because a proc is called inside another proc (or something like that) and you have permissions to see the proc, running this little code snippet...
April 18, 2014 at 6:31 am
NineIron (4/18/2014)
if the underlying table(s) is not indexed or poorly indexed (I have little control over this), will an indexed view work to speed up performance?
Yes and no. The problem...
April 18, 2014 at 6:25 am
Perry Whittle (4/18/2014)
Tony Sweet (4/17/2014)
It does not release RAM until you cycle the service or the OS tells it to give up the RAM.
or if you lower the max memory...
April 18, 2014 at 6:22 am
My w.a.g. is that probably a brackets issue. Domain\User usually needs to be surrounded by square brackets [Domain\User] or it causes issues in the drop statements. It appears at first...
April 18, 2014 at 6:19 am
I mostly agree with Grant, but I would put the Reporting database on the same instance as the non-mission critical (and rarely used) databases. That way any reporting doesn't interfere...
April 18, 2014 at 6:15 am
I always run into this problem when it's an object with a different schema than dbo. See if my article about Dropping Schema Owned Tables[/url] helps you out. It's about...
April 18, 2014 at 6:12 am
Are you running the job and package on the same server as the database? That's the only reason why I can think you might not see the SPID. You may...
April 18, 2014 at 6:06 am
This sounds like a contest or homework problem to me.
April 18, 2014 at 6:00 am
Viewing 15 posts - 3,226 through 3,240 (of 9,712 total)