Viewing 15 posts - 706 through 720 (of 1,319 total)
select into will work if it's a linked server and you use the four-part naming convention as follows: select * into servername.dbname.objectowner.tablename from sourcedbname..sourcetable
April 9, 2009 at 8:45 am
twantoni (4/8/2009)
Flo,I don't believe the index is tied directly to the column I'm trying to update but I can't figure out what it is tied too.
Just because you are updating...
April 9, 2009 at 8:41 am
Perry Whittle (4/8/2009)
"Au contrair mon pere"😉
Haven't heard that in "forever". Thanks for the early morning laugh....
April 9, 2009 at 7:45 am
Krishna Potlakayala (4/9/2009)
sudhirrsingh.parmar (4/9/2009)
I also have 5 day old full backup of my database.
And also how come you don't have a recent backup ? What are your business...
April 9, 2009 at 7:34 am
Jeff Moden (4/7/2009)
April 7, 2009 at 6:53 am
The site gives us a welcoming forum but it's the people who visit who truly make the site. Thanks to Steve for providing us with the vehicle but it's all...
April 7, 2009 at 6:37 am
Very familiar tone from the OP. Isn't this the same guy who insisted cursor based solutions were superior to set based and played the "riddler" for a week or so...
April 2, 2009 at 2:29 pm
Sunny, good point about IIS. I hadn't realized IIS was not installed on the SQL server but was on the app server.
Bobby, another good point. I think by hitting the...
April 2, 2009 at 6:48 am
george sibbald (3/28/2009)
Hi.............
and then awaits my reply.
I know they just want me to do something for them....
March 30, 2009 at 6:26 am
Katie Walker (3/27/2009)
The other big one that annoys me are people who open the beer cans in their cubes before the 5 o'clock bell rings. Or they display every bottle...
March 27, 2009 at 12:27 pm
Probably already stated in a prior post (I don't have time to cover 60 + posts at the moment) but I wanted to chime in. One of the guys in...
March 27, 2009 at 12:24 pm
Still, a cursory look of the event logs on the server or maybe some disk checks could be well worth the time spent - IMO. I've never seen an application...
March 26, 2009 at 2:50 pm
Beautiful as I have just begun the task (tday, actually!) of upgrading to 2005.
March 26, 2009 at 2:31 pm
So with the sniffer, they could intercept packets and potentially see the data or is it more complex than that? This reason this has come up is we are about...
March 26, 2009 at 10:34 am
Viewing 15 posts - 706 through 720 (of 1,319 total)