How could I copy several tables from one owner to other in the same database ????? I have a database with around 150 tables with constraints checking several relationships, indexes, etc. (but without store procedures) I want to copy all of them to other owner (that I already have), in this case the destination owner […]
2004-05-11
1 reads
Here are some sources of DTS information if you decide to investigate John's suggestion further.Executing DTS from ASP: see http://www.sqldts.com/default.aspx?207Control access to DTS packages with owner and user passwords. see "Handling Package Security in DTS" in BOL.You can pass parameters to a DTS package by using a Dynamic Properties Task and global variables. See both […]
2004-05-11
I have a case like this:table a - has one filed with statusIDtable b - has one filed with statusIDc - status code tbl - statusID(int,4), status Decription (char, 20)When I want to pull the description for the statuses I have in "a" and "b" for a particular custID (they will be always different) I could use:select * from a […]
2004-03-24
3 reads
HiFor my project i am trying to create an online registering system. The users enter all of the required info through the form it is then handled on the server by asp scripts.I have to tables resident and householdresident table:----------------------------------------Personal_ID (PK) | Name | DOB | Household_ID Household table:----------------------------------------Household_ID (PK) | Address | Post Code The problem i […]
2004-03-04
2 reads
no, i checked that. autoclose is turned off. is there maybe a way to establish a permanent or cached connection between the web server and SQL server or set SQl server up differently?
2004-02-12
Forgive me for this (my mood management today has failed), but you might suggest your boss to post to Microsoft SQL Server newsgroups. With a little bit of luck Joe Celko will respond. Would he be reputable enough? If so, be prepared for an offending reply. Even if you go up on several hundreds of […]
2004-01-14
1 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers