Viewing 15 posts - 3,616 through 3,630 (of 7,429 total)
You get no bennifits from seperate drives on the same RAID controller and same channel because access for the controller will switch between each RAID on the same channel and...
January 10, 2003 at 4:23 pm
In sql you do it like this but you really need to know how many columns you are pivoting on. ( I did post a script for unknown number of...
January 10, 2003 at 6:06 am
For securiy it is most restrictive of combined permissions take effect. So if you deny INSERT and allow UPDATES thru one role but have db_denywrite set shee will not be...
January 10, 2003 at 4:41 am
May be a little slow on the initial process if done via Transactional replication simple because only changes are delivered there after. However, if something causes a need to resend...
January 10, 2003 at 3:49 am
All the code has to be wrapped in an Execute or sp_executesql string input. You cannot substitute a table with a variable.
January 10, 2003 at 3:34 am
What version of SQL Server are you running? And how did you define the link (server name, driver, etc (no security info thou))?
January 9, 2003 at 2:25 pm
As for the qork table thing it is due to the ORDER BY in general. Small tables and sometimes easily fetched larger sets with good indexes will be sorted in...
January 9, 2003 at 2:16 pm
Have been looking at TOAD (Freeware version) and for Oracle it Rocks. Anway, I know of no tool along the same lines as TOAD but Quest does have serveral SQL...
January 9, 2003 at 2:08 pm
Unfortunately that is where things get fuzzy for me and I don't know for sure what to do with MySQL as a linked server. I also don't have a server...
January 9, 2003 at 4:45 am
I think qruntime meant sp_dropserver to try and remove it.
January 8, 2003 at 7:22 pm
If you are using a Server name the resolution may be taking too long setup Client network Utility with the name and the IP to shorten the time making sure...
January 8, 2003 at 7:19 pm
I like the Exam Cram and the Exam Prep books. However, I will say even then you should practice and verify thru other sources as I have come across errors...
January 8, 2003 at 7:17 pm
Not sure the syntax is compatible but you can always you the DDL script or do a generate script from the task options in EM then make the needed changes...
January 8, 2003 at 6:43 pm
Is SQL itself running under Local System Account as it's service provider account or a Machine account. I want to say that maybe using it this way actually uses the...
January 8, 2003 at 4:50 pm
Viewing 15 posts - 3,616 through 3,630 (of 7,429 total)