Viewing 15 posts - 5,461 through 5,475 (of 9,715 total)
Could you clarify what you're looking for in the result set. As you can see from the back-n-forth here, we all have different thoughts about what you're looking for.
July 27, 2011 at 7:19 am
bopeavy (7/27/2011)
Ray K (7/27/2011)
WOTD: coffeeTea
Green
July 27, 2011 at 7:17 am
- Win. (7/27/2011)
Administrative Tools -> Local Security Policy -> New window - >Local Policies -> User Rights Assignment...
July 27, 2011 at 7:16 am
SQL_Surfer (7/27/2011)
SQLServerAgent could not be started (reason: SQLServerAgent must be able to connect to SQLServer as SysAdmin,but '(Unknown)' is not a member of the SysAdmin role).
Does the new account...
July 27, 2011 at 7:15 am
Is there a problem with restarting SQL Agent? (which is required when you change accounts).
July 27, 2011 at 6:28 am
You'll want to start posting in the Certification thread to get answers. But just an FYI: No SQL 2005 exams are open anymore. They all closed in June. The only...
July 27, 2011 at 6:26 am
Lowell (7/27/2011)
Riskworks (7/26/2011)
When I call it from another Proc I get an error saying...
July 27, 2011 at 6:21 am
Look into the Patindex and Charindex functions (you can find them in Books Online by searching for those keywords). You can use those to determine where the @ is, then...
July 27, 2011 at 6:15 am
Then take Chris's code and adjust it. Expand the temp table's column list, making sure the Name column is the first one, then do the insert as he says. Make...
July 27, 2011 at 6:13 am
Eugene Elutin (7/27/2011)
....
If you are right,...
July 27, 2011 at 6:08 am
I'm almost scared to ask...
Why are you changing the registry setting for collation? And to a value that isn't even a proper collation value?
July 27, 2011 at 6:00 am
Glad we could help. Let us know what you find out.
July 27, 2011 at 5:50 am
Eugene Elutin (7/27/2011)
Brandie Tarvin (7/27/2011)
...You can't have line item detail and a summary together that will display correctly in SSMS. You get to pick: Detail or Summary. Not both.
...
You can...
July 27, 2011 at 5:46 am
Thanks for the link. It explains why I can't figure out what State is being used for. So far, it's not.
July 27, 2011 at 5:41 am
Does "name" in the first result come close to being the same datatype of any of the columns in the second result set?
July 27, 2011 at 5:38 am
Viewing 15 posts - 5,461 through 5,475 (of 9,715 total)