WayneS

Forum Replies Created

Viewing 15 posts - 4,906 through 4,920 (of 5,588 total)

RE: Having trouble connecting to a cluster in single-user mode with a DAC connection.

GilaMonster (12/29/2009)
You're 100% sure that remote DAC is enabled?
EXEC sp_configure 'remote admin connections'
Yes. Above code returns:
nameminimummaximumconfig_valuerun_value
remote admin connections0111
(wish there was an IFCode for doing tables...)
And in the sql logs when...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

December 29, 2009 at 11:00 am

#1097141
RE: Having trouble connecting to a cluster in single-user mode with a DAC connection.

GilaMonster (12/29/2009)
So it's not a login failure. The connection request is never reaching SQL. If it was, there would be a 'login failure' in the error log.
Is there a firewall...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

December 29, 2009 at 8:58 am

#1097067
RE: Having trouble connecting to a cluster in single-user mode with a DAC connection.

GilaMonster (12/28/2009)
WayneS (12/28/2009)
GilaMonster (12/28/2009)
WayneS (12/27/2009)
4. Open a new query. Connect as "ADMIN:ServerName" - login fails.
With what message? Check the error log for the reason that the login failed. Should a...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

December 29, 2009 at 7:38 am

#1097027
RE: Having trouble connecting to a cluster in single-user mode with a DAC connection.

GilaMonster (12/28/2009)
WayneS (12/27/2009)
4. Open a new query. Connect as "ADMIN:ServerName" - login fails.
With what message? Check the error log for the reason that the login failed. Should a non-zero state...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

December 28, 2009 at 4:36 pm

#1096868
RE: Can't delete secondary db file

Glenn Dorling (12/23/2009)
You can do this using an ALTER TABLE command and specifying a different filegroup for the BLOB data. ALTER TABLE can also be used to move data...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

December 24, 2009 at 9:39 am

#1096339
RE: Can't delete secondary db file

sturner (12/23/2009)
I am not aware of a way to do this other than creating a new table having the same structure as the old one. Specify the desired file groups...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

December 24, 2009 at 9:33 am

#1096336
RE: Values from row to columns as indicator

You might want to check out this article on Cross Tabs and Pivots[/url].
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

December 14, 2009 at 3:29 pm

#1092268
RE: Are the posted questions getting worse?

Alvin Ramard (12/14/2009)
GSquared (12/14/2009)
CirquedeSQLeil (12/11/2009)
By the time the thread hits 10,000 y'all will be flatlined, passed out drunk from all the bear being passed around - bwahahaha 10,000 shall be...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

December 14, 2009 at 12:09 pm

#1092148
RE: Generate XML file without using BCP utility

You can also utilize the sp_OA procedures with "Scripting.FileSystemObject" to create a file with whatever text in it you want.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

December 14, 2009 at 10:36 am

#1092091
RE: Common Table Expression inside View

before the with: ";with Publisher"
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

December 14, 2009 at 10:31 am

#1092087
RE: Getting Timeout when run from web or open view

Update:
I used the script that drops / creates the linked server and synonyms, and pointed it to another server.
The web site worked just fine connecting to this server.
I used the...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

December 4, 2009 at 10:30 am

#1087893
RE: The Sixty-Second Guide to becoming a SQL Server DBA

SuperDBA-207096 (12/4/2009)
Barry,
Pretty good article - it could launch someone down the path of becoming a DBA. Lots more to becoming a DBA, but it's a start.
I like the idea...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

December 4, 2009 at 9:36 am

#1087842
RE: Are the posted questions getting worse?

GSquared (12/4/2009)
Yeah, my mistake on this one. You already did what I was suggesting.
Fair enough. NP.
Best of luck with your situation Gus. Definitely something not needed, especially at holiday...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

December 4, 2009 at 9:23 am

#1087834
RE: Are the posted questions getting worse?

Lynn Pettis (12/4/2009)
GSquared (12/4/2009)
WayneS (12/4/2009)
Hey gang...
I'm having a weird issue. I can run a select * from a view from SSMS, no problem. Web site can't run it, and can't...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

December 4, 2009 at 9:13 am

#1087826
RE: Are the posted questions getting worse?

Hey gang...
I'm having a weird issue. I can run a select * from a view from SSMS, no problem. Web site can't run it, and can't open the view from...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

December 4, 2009 at 8:35 am

#1087794

Viewing 15 posts - 4,906 through 4,920 (of 5,588 total)