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
...
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...
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...
April 15, 2011 at 7:11 am
Craig Farrell (4/14/2011)
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.
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.
April 14, 2011 at 10:02 am
Can you connect if you specify the port in your connection? ServerName\Instance,Port
April 14, 2011 at 9:32 am
Glad I could help.
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. ...
April 14, 2011 at 8:18 am
Yeah, walking away from a half done job proves that you do have integrity.
April 13, 2011 at 9:03 pm
Steve Jones - SSC Editor (4/13/2011)
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...
April 13, 2011 at 5:02 pm
I'd be interested in hearing what you come up for a solution.
April 13, 2011 at 4:36 pm
LutzM (4/13/2011)
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...
April 13, 2011 at 2:52 pm
Viewing 15 posts - 2,446 through 2,460 (of 9,643 total)