Viewing 15 posts - 39,481 through 39,495 (of 39,717 total)
You might also want to detach your dbs and make a copy of the raw mdf/ldf/ndf files.
Steve Jones
October 15, 2001 at 2:17 pm
Look them up in BOL, but basically you split your table by the PK into 2 parts. If your table is orders using an OrderID (int) as a PK, you...
October 12, 2001 at 3:51 pm
run from command prompt:
osql -Sserver -E -Q"select * from test1" >> file.txt
Or run from DTS package.
Steve Jones
October 12, 2001 at 2:33 pm
or you can use
xp_cmdshell 'osql -Sservername -E "sp_helpdb" > test.txt'
etc.
Steve Jones
October 12, 2001 at 11:32 am
What you need to do is handle this in the ASP.
Use your loop to check for the name and only print it (and a new line) if the name has...
October 12, 2001 at 11:23 am
Also, MCSEs retain their cert. There will not be MCSE 4 and MCSE 2000.
In addition there is a new sys admin cert MCSA.
Steve Jones
October 12, 2001 at 9:47 am
I wouldn't run this from a trigger. If you have problems, then the transaction would fail. I'd use the trigger to insert the record into a staging table with a...
October 11, 2001 at 9:33 am
When you say 3 RAID 5 disks, is this one RAId-5 array with 5 disks of 18GB apeice?
If so, just make a single file/filegroup. I have usually split the system...
October 10, 2001 at 4:06 pm
Can you give us a better idea of what is inside the packages? Is it a single connection/T-SQL task?
Also, what is different about the client machines? Did you check to...
October 10, 2001 at 4:02 pm
In 2000 there are a number of collation type options that can be reset per db. In 7.0, I do not think this is an option. Sorry, I do...
October 10, 2001 at 4:00 pm
October 10, 2001 at 3:54 pm
With SQL Server 2000, you also have DTS which facilitates the movement of data between two different places. Neither of these have to be SQL Server, they can be Excel,...
October 10, 2001 at 12:04 pm
you can have your page load a partial page with an image or text in a <div> tag. Then when the page completes, make this invisible.
I don't have an example...
October 10, 2001 at 11:52 am
October 10, 2001 at 11:44 am
I'd look at using DTS, but perhaps to a staging table. Then you can use stored procedures to queries to move the data while maintaining the foreign keys.
Steve Jones
October 10, 2001 at 11:39 am
Viewing 15 posts - 39,481 through 39,495 (of 39,717 total)