Viewing 15 posts - 1,516 through 1,530 (of 9,699 total)
A few things to consider. Does the junior DBA need some mentoring? Is this a go-getter type of person or someone who just sits around waiting for other people to...
August 11, 2016 at 8:55 am
TheSQLGuru (8/9/2016)
SQLJudo did a 30-day series on creating your own SSMS Add-in. Why don't you just build what you need (and then make a product out of it and become...
August 11, 2016 at 4:37 am
Phil Parkin (8/9/2016)
EXEC master.sys.xp_create_subdir @DatabaseDailyFolder;
If so, I think you might have to modify your code to capture the execution status of the xp...
August 11, 2016 at 4:35 am
SQLRNNR (8/10/2016)
Brandie Tarvin (8/10/2016)
Sean Lange (8/10/2016)
Brandie Tarvin (8/10/2016)
SQLRNNR (8/9/2016)
Brandie Tarvin (8/9/2016)
I am experiencing that sinking feeling one gets when one realizes an instance of SQL was installed without a sysadmin...
August 11, 2016 at 4:09 am
Sean Lange (8/10/2016)
Brandie Tarvin (8/10/2016)
SQLRNNR (8/9/2016)
Brandie Tarvin (8/9/2016)
I am experiencing that sinking feeling one gets when one realizes an instance of SQL was installed without a sysadmin account.
To be fair,...
August 10, 2016 at 12:10 pm
SQLRNNR (8/9/2016)
Brandie Tarvin (8/9/2016)
I am experiencing that sinking feeling one gets when one realizes an instance of SQL was installed without a sysadmin account.
To be fair, I don't know for...
August 10, 2016 at 11:54 am
Luis Cazares (8/9/2016)
Did you try increasing the max token size as suggested in here:https://msdn.microsoft.com/en-us/library/cc645913.aspx?
No. Because my Google-Fu didn't uncover this page. Thanks for the link. I'll check it out.
August 10, 2016 at 5:42 am
Sigh.
I am experiencing that sinking feeling one gets when one realizes an instance of SQL was installed without a sysadmin account.
To be fair, I don't know for sure that the...
August 9, 2016 at 11:32 am
TheSQLGuru (8/3/2016)
Brandie Tarvin (8/3/2016)
I appreciate the suggestion, Eric. But my hands are tied on third party software. We're not allowed to use unapproved stuff. Hence hacking SSMS Object Explorer Details...
August 9, 2016 at 9:38 am
Well, this is heartbreaking...
Poking around AdventureWorks, I get stuff like this in SQL 2008.
exec sp_executesql N'SELECT
udf.name AS [Name],
SCHEMA_NAME(udf.schema_id) AS [Schema],
''Server[@Name='' + quotename(CAST(
serverproperty(N''Servername'')
...
August 9, 2016 at 9:32 am
Phil Parkin (8/9/2016)
It's probably obvious, but I didn't see it. Which line of code is...
August 9, 2016 at 6:20 am
Luis Cazares (8/5/2016)
djj (8/5/2016)
Brandie Tarvin (8/5/2016)
So I'm importing...
August 9, 2016 at 6:07 am
Phil Parkin (8/5/2016)
ThomasRushton (8/5/2016)
Brandie Tarvin (8/5/2016)
So I'm importing...
August 9, 2016 at 6:05 am
A million things to do at work and they want me off my PC. I've got a new one I've got to configure.
So I'm importing my outlook rules, my IE...
August 5, 2016 at 5:52 am
Eirikur Eiriksson (8/4/2016)
Nice input Brandy, appreciate it:-) Maybe the OP can enlighten us on the issue?😎
There's also the issue of the final sort order. Lynn's results are sorted differently than...
August 4, 2016 at 9:01 am
Viewing 15 posts - 1,516 through 1,530 (of 9,699 total)