Hi, I'm new to SQL server. I have a question btw MS SQL server and Microsoft SQL Server2000 Desktop Engine. What is different btw MS SQL server and Microsoft SQL Server2000 Desktop Engine ? As knowledge, MSDE can choose be as an database engine for application (like: MS excess). Can i...more >>

I know the max row size in SQL Server is 8060, but what happens if I go over the max row size. Will some of the data be lost? Will I have problems with backing up the database or importing or exporting data? Also, does the 8060 size apply to rows in Views also, or is it just for tables? ...more >>

Hi all, I have inherited a custom build application that is being nominated to get replaced by something else (which is not known for know). The company who created the application is gone and while the application was reasonable good it won't run with XP SP2. The application uses a dat...more >>

Can someone pls let me know the location from where i can download SQL 2005 latest beta release. Regards, bobby...more >>

I'm doing a MSDE install on a Windows 2000 server. The client has Office (including MS Access) installed on the server. When I try and install the SQL Tools, it runs through the process, but there is no SQL Server folder under Program Files, nothing is added to the Programs menu. Is ther...more >>

I have a log file that is pretty large, but I cannot see it inside Enterprise manager. It just shows an hourglass when I click on the log. I would like to see even part of it if possible. Where do I look for the file and what do I use to possibly copy 10% of the file? Thanks, Roger ...more >>

Hello I want to find who and when the changes wasdone to a particular database or table into the database of SQL 2000 server. Is there any way to monitor it ? With regards Ashutosh...more >>

Hello. I am responsible for backing up two Windows 2003 servers, one of which contains a non-simple SQL database. The tapedrive is a DLT1 without any automated loading (I must load a new tape each day by hand). I am using Microsoft's built in backup software, to backup all the important...more >>

I am having trouble finding my SQL server from a remote SQL server running 2000. Please help....more >>

I have two tables with the same layout, and I need to join them in a way that all the records from each table will be "on top" of each other (not sure how else to word that). For example: Table 1 records: A B C Table 2 records: 1 2 3 I need my output to look like this: A B ...more >>

I currently have 2 tables. Both have ssn's of an employee. I'm trying to pull 2 fields, de_code and amount, from one of the tables based on the ssn and the de_code like EIC (which is just a value in de_code). I'm having trouble merging those 2 fields into the other table. Should I instead ...more >>

I am looking into pulling Exchange Mailbox data directly in SQL. Currently, we export the data from Outlook manually and then import into the data into SQL. We would like to bypass the import/export to a text file piece. Could someone point me in the right direction? I had heard this could ...more >>

Hi all, 1- Which better data types for money fields, float or decimal? Which i use? (... my money type requires 6 decimal point ...x.123456) 2- I m using User Defined Data Types. Is the UDDT supported Alter with data? When i think change in future. 3-How do i reject new records in...more >>

I currently restored a databae from another agency with a 4.5 G .bak file. After restoring I was questioned why the databaes was so huge. I used the sp_spaceused stored procedure and it reported 3.7 G used. There are approximately 700 tables but many of them have no rows. From the small ...more >>

Hi all, I'm wanting to change all of these Update queries into a single view. Pretty new at this and would appreciated the help. Cheers, Job Update Tbl_Txn_Line_CHS Set LP_AdjandPay_Not_0 = CASE WHEN (LnPstAdj = 0 and LnPstPymnt = 0) THEN 0 Else 1 END Update Tbl_Txn_Line_CHS Set wP...more >>

I have to create a database application (multiuser) for about 15 users using SQLExpress and C#. I am very new to SQLExpress so I need some basic direction. Do I put the data file on the network drive and install SQLExpress on each machine or do I install the data file and SQL on the network,...more >>

When we create a diagram which defines the relationship between two tables, there is no way to specify the exact reltionship type, as there is in Access. We need to create a relationship that is, in SQL, a left outer join. In access, this is easy (gives you three radio buttons and you pick ...more >>

Hi, any help is appreciated. I dont know the best way I can do this fast and easily. What I want to do: Move a MAX value of a column to a variable from my SQL Server and be able to store it as a table or other recommended way, once this is done I want to be able to query this variable from my ...more >>

I am very new to SQL Server 2000. We have SQL Server 2000 SP 3 on Windows 2000 SP4. I have 4 instances running on the server. I am able to register the 4 instances in my copy of Enterprise Manager at my desktop and using Windows authentication with out issue. But, after a day or two or som...more >>

I have a column in a table full of phone numbers, except the user entered them just as "a number" so (206) 555-1212 looks like 2065551212 Is there a way in which I can run something that will format all of these with the appropriate parantheses, etc...? (ie. make them look like phone numbe...more >>

I want to copy the sql server database from the C drive (IDE) to a raid drive E. So I first created a directory and copyed the pair of mdf and ldf file to the E drive and then ranamed them. This didnt work because when I attached the files sql somehow knew they came from the C drive and entered...more >>