finding related tables on DB with no documentation or diagrams?

theres a rather large DB system on a server where i work. i have to link it to another large server DB. the prob is that theres no documentation or diagrams on what tables are related and what columns are for. are there any programs/qwueries that i can run on a DB that will allow […]

RE: Computer grabbing all IP Adresses - is SQL Server instance involved?

Okay, that's a bit different. You say it's choking all the network traffic and it's exposed to the Internet. When you get a chance, if you issue a @@VERISON on it, what is returned? Also, is there anything between the SQL Server and the Internet that provides any filtering... firewall, etc?

RE: String Manipulation

I've figured it out using a combination of Substring and Charindex!

Error: No mapping between account names and security IDs was done.

No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!

RE: Best data type for storing "Hours"

Smallmoney is 4 bytes and has a maximum of 214,748.3647 To hold the equivalent in decimal would be 9 bytes decimal(10,4)However if you are only storing to 2 decimal places then smallmoney would still be 4 bytes and a maximum of 214,748.3647 but numeric(9,2) is 5 bytes with a maximum of 9,999,999.99It depends if you […]

To execute sp_change_users_login procedure with all the three...

Which Approach? Job Steps or DTS Tasks

Should I create a job that runs a large DTS package with many tasks or create a job with many steps in which each step runs a small DTS package with a few tasks. What are the pros\cons of each approach?TIADean 

Bill's company recently purchased another company and he...

RE: cluster - "trend micro" antivirus software

same here, email, not SQL.

RE: Connection to Server Failed (Analysis Sevices)

P.S.I can ping it using the servers text name.