Viewing 15 posts - 2,446 through 2,460 (of 9,643 total)
Here are 2 ways:
CREATE TABLE #table (id INT) ;
SELECT
*
FROM
sys.tables AS T
WHERE
T.name LIKE '#table%' ;
-- OR
SELECT
...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 15, 2011 at 1:22 pm
I'm not sure what you mean. I need the column names so I know what columns you are showing in your post as they don't appear to match the...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 15, 2011 at 9:21 am
Ask me how I'm doing in July because until then I really won't know. I've been in my current position for almost 4 years and it is ending at...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 15, 2011 at 7:11 am
Craig Farrell (4/14/2011)
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 14, 2011 at 2:37 pm
Processor architecture shouldn't matter for connections.
I've run the script in my environment (different query) and it has worked. I'm not sure what's happening in your environment.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 14, 2011 at 12:23 pm
can you post your vbscript code or at least the connection string?
Also you have not posted the error you getting, so can you post that as well?
Thanks.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 14, 2011 at 10:02 am
Can you connect if you specify the port in your connection? ServerName\Instance,Port
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 14, 2011 at 9:32 am
Glad I could help.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 14, 2011 at 8:34 am
Okay, that is the most common reason. The second reason is often Windows Firewall. You need to make sure the proper ports are open in the firewall. ...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 14, 2011 at 8:18 am
Yeah, walking away from a half done job proves that you do have integrity.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 13, 2011 at 9:03 pm
Steve Jones - SSC Editor (4/13/2011)
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 13, 2011 at 7:02 pm
I'm not sure exactly what you want, but this will get you only the rows with the lowest sourcetype and when the student has more than one entry in the...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 13, 2011 at 5:02 pm
I'd be interested in hearing what you come up for a solution.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 13, 2011 at 4:36 pm
LutzM (4/13/2011)
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 13, 2011 at 3:11 pm
LutzM (4/13/2011)
You might want to have a look atJacob Sebastians blog (title: "How to find all stored procedures used by Report Server?") 😉
Awesome. I thought it had to...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 13, 2011 at 2:52 pm
Viewing 15 posts - 2,446 through 2,460 (of 9,643 total)