WayneS

Forum Replies Created

Viewing 15 posts - 4,636 through 4,650 (of 5,588 total)

RE: I have successfully removed SQL Server 2005 from the SQL2 node because of a bad install

Delete each of the resources under the resource group, then delete the resource group itself (right-click, select delete).
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

March 22, 2010 at 2:44 pm

#1137847
RE: Cannot generate SSPI Context

No. If this isn't your issue, then I'd look into the network. This error message pops up a lot with Kerboros authentication failure messages, so I'd start by looking there.
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

March 22, 2010 at 2:40 pm

#1137845
RE: How to get unused numbers from 1 to 99999

Bitter Monkey (3/22/2010)
Hi,
I have a table where the Primary key (for an ID field) is not incremental and therefore doesn't follow a sequence. How do I get the unused...
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

March 22, 2010 at 2:32 pm

#1137843
RE: QOD Improvement to question creation page

CirquedeSQLeil (3/22/2010)
I think we need to be careful here. I would keep the list short. You don't want to have to answer 20 questions about your question just...
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

March 22, 2010 at 2:18 pm

#1137835
RE: QOD Improvement to question creation page

bitbucket-25253 (3/22/2010)
Posted as an attachment is a modified view of a section of the web page, including WayneS first recommendation.
CirquedeSQLeil
I think one good way to circumvent that is to paste...
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

March 22, 2010 at 2:14 pm

#1137832
RE: Cannot generate SSPI Context

dwh-1095413 (3/22/2010)
id 0 is the name that the local server should be. The is_linked column is 0.
...and...
The @@servername is not the same. I have run the 2 queries but...
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

March 22, 2010 at 2:06 pm

#1137830
RE: Cannot generate SSPI Context

dwh-1095413 (3/22/2010)
I have 2 servers:
Server A is on Windows 2003 R2 with SQL Server 2005
Server B is on Windows 2008 with SQL Server 2008
Both were working perfectly fine. We wanted...
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

March 22, 2010 at 1:37 pm

#1137819
RE: T-SQL Oddities

deepforest (3/22/2010)
But, did you know that the following will compile just fine and it'll work as well?
Why, yes. 😛
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

March 22, 2010 at 1:18 pm

#1137810
RE: RegexMatch Help

CrazyMan (3/22/2010)
Hi Wayne
When execute the above string , i must be able to get only the values 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

March 22, 2010 at 1:14 pm

#1137805
RE: QOD Improvement to question creation page

bitbucket-25253 (3/22/2010)
WayneS
I'd suggest on the web form, having the submitter actually select the sql version that it's applicable for via checkboxes
- take this to be a sort of...
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

March 22, 2010 at 12:49 pm

#1137787
RE: xp_dirtree works in SQL 2000 but not 2005

Olga B (3/22/2010)
Yes, xp_dirtree worked on local folder in 2005.
Anyway, mystery is solved, kinda. I found today that all SQL Server services are stopped. :crazy: This is a new...
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

March 22, 2010 at 12:41 pm

#1137781
RE: Are the posted questions getting worse?

CirquedeSQLeil (3/22/2010)
Lynn Pettis (3/22/2010)
CirquedeSQLeil (3/22/2010)
Going on 15 for me. Feels like about 5 - until I try to remember details of those early years. It's hard to remember...
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

March 22, 2010 at 12:30 pm

#1137770
RE: QOD Improvement to question creation page

1. I'd suggest on the web form, having the submitter actually select the sql version that it's applicable for via checkboxes instead of just saying in the question what version...
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

March 22, 2010 at 11:32 am

#1137711
RE: RegexMatch Help

CrazyMan (3/22/2010)
Thanks Wayne, this works, but got one more doubt, is there any other way to get numbers between 1 and 100 in the given string ?
I don't quite understand...
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

March 22, 2010 at 10:13 am

#1137668
RE: Alert when Sqlserver Instances stops.

I can't think of any way that a specific server can alert you that it's services have shut down. You will need to use a process where an external server...
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

March 22, 2010 at 9:47 am

#1137657

Viewing 15 posts - 4,636 through 4,650 (of 5,588 total)