Here are 2 ways:

CREATE TABLE #table (id INT) ;

SELECT

*

FROM

sys.tables AS T

WHERE

T.name LIKE '#table%' ;

-- OR

SELECT

...

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...

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...

Craig Farrell (4/14/2011)

---

Thanks for all the support folks. Now if I can ever find a weekend off I will finish editing the other one that I've got 90% of...

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.

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.

Can you connect if you specify the port in your connection? ServerName\Instance,Port

Glad I could help.

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. ...

Yeah, walking away from a half done job proves that you do have integrity.

Steve Jones - SSC Editor (4/13/2011)

---

At one point we had a page peel there that opened and covered up the entire screen. I think it was from Quest, but it...

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...

I'd be interested in hearing what you come up for a solution.

LutzM (4/13/2011)

---

I agree, the image data type is not the one someone would expect to find such valuable information. It's also strange that MS still uses the text/ntext data type...

Awesome. I thought it had to...