Viewing 15 posts - 20,806 through 20,820 (of 22,196 total)
True. But based on what he had posted above I assumed he was already doing that much.
March 17, 2008 at 12:49 pm
Not disagreeing, but I'd say the biggest tip would be to find some other method because they become a glaring security hole. But, if you absolutely, positively have to communicate...
March 17, 2008 at 12:47 pm
Look up the topic "Linked Server" in the Books Online. That will get you started.
March 17, 2008 at 11:59 am
Try running Profiler over that same period of time. You'll see what exactly is getting called. Be sure you capture before & after the event in case a process runs...
March 17, 2008 at 11:33 am
You might wait a bit and see if anyone else posts anything else interesting here. You are working in an area where there is room for interpretation and others might...
March 17, 2008 at 9:03 am
Indianrock (3/17/2008)
March 17, 2008 at 8:52 am
Yeah, that's a lively set of responses.
One thing that did come up over there that I should have raised, what are you using the schema's for? Is it to seperate...
March 17, 2008 at 8:17 am
Someone might know the answer, but the forum here is for Microsoft SQL Server 2005. You'll more likely to get information by posting that question at a forum for the...
March 17, 2008 at 7:40 am
You're going to hate this answer... It depends.
I think it really depends on the definitions of the tables. I also think different people are going to have different approaches. For...
March 17, 2008 at 7:36 am
Sure. Sorry I couldn't help.
You might run into problems with those non-ansi joins too.
Instead of "FROM X, Y WHERE X.Id = Y.Id" you would use "FROM X INNER JOIN Y...
March 17, 2008 at 6:03 am
It's just a server with databases on it as far as normal operations are concerned. You shouldn't have any issues of any kind running a restore.
March 14, 2008 at 12:29 pm
Amit Tiwari (3/14/2008)
I have a table having Five Columns
CREATE TABLE TABLE_X (
Col1 INT NOT NULL,
Col2 varchar(10) NOT NULL,
Colc Datetime NOT NULL
)
PRIMARY KEY CLUSTERED IS ON COL1 & COL2.
THERE is...
March 14, 2008 at 9:21 am
WILLIAM MITCHELL (3/14/2008)
Since the status column is an int, I am guessing that there is a table of statuses that gets joined on the status column, so I would think...
March 14, 2008 at 9:14 am
I served mainly on pretty small boats & ships (short time on an LST) so I didn't see any of the crews I worked with die. Considering some of the...
March 14, 2008 at 7:37 am
Viewing 15 posts - 20,806 through 20,820 (of 22,196 total)