Can someone help me how to add records from one table that has more columns to a table that has less and some column names not exactly the same. Is it possible to use a select statement to accomplish this? Thank you for the help....more >>

I am using MSDE2000A and in OSQL.exe I try this: 1> CREATE TABLE SomeTable ( 2> tk_Code INT IDENTITY(1, 1) PRIMARY KEY, 3> tk_Text NVARCHAR(MAX) 4> ) 5> go Msg 170, Level 15, State 1, Server TARKOVSKI, Line 3 Line 3: Incorrect syntax near 'MAX'. 1> What is ...more >>

I don't know what I am doing wrong but this create error: 1> CREATE TABLE SomeTable ( 2> tk_Sifra INT IDENTITY(1, 1) PRIMARY KEY, 3> tk_Tekst NVARCHAR(MAX), 4> ) 5> go Msg 170, Level 15, State 1, Server TARKOVSKI, Line 3 Line 3: Incorrect syntax near 'MAX...more >>

We have an data-intensive application that runs for several hours and produces a huge amount of data. The problem is that the transaction log gets very big very quickly and we have to frequently run a job to truncate, backup, and shrink the log. However, when the job is running we get connec...more >>

I need to populate many fields in a column of a table, now that I have the information that goes there. I can't repost the entire table with the new data because the table is now live, underlying a website, and new records are being added regularly. Some who are only slightly more experienced t...more >>

Hi friends, First of all sorry for my english. I'll be very happy if someone can help me. I am doing web page with vb.net and sql server, the problem is with registration. I am using user name and password which the user can set. The problem is that if I already have user with user n...more >>

Sigh. I am creating a View, and in it I need to calculate the values in two columns as another column. Before I run the calculation, however, I need to make sure one of the values is not 0, null, or empty. I'm having trouble figuring out how to do it, though. The field I'm testing is "money...more >>

I've looked up the syntax, but since I'm not familiar with datatypes, I'm not certain how to work this. I have two money datatypes that I need to calculate to find a percentate. My formula is: ((moneytype1/moneytype2)*100) I'm getting error: Implicit conversion from data type money to ...more >>

I need to do a calculation on two numbers in a View. If one of the numbers is 0 (zero), null, or empty, I can't do the calculation and need to instead assign 0 value to the output/result. Here's what I have: CASE WHEN (aipdn.VIEW_016_ALLMONTHS.Y2004 <= 0) OR (IsNumeric(aipdn.VIEW_016_ALL...more >>

I have a client who wrote a very large, ugly SELECT statement for a view and it is not working and they want us to debug it. Is there a method in SQL Server to do an EXPLAIN on SQL? Thanks! Mary Jo ...more >>

Is there a way to run the user interface tools for SQL Server, such as Enterprise Manager and Query Analyzer, from two different computers on a network, or do you need a separate license for each computer that will be running them? We are considering migrating to SQL Server, and we will have t...more >>

Hello Everyone, I am attempting to learn how to use the email facilities within SQL server. I have MSSQL running on Win2K3 server with an Outlook 2003 mail client. I set up a simple job which backs up my databases on a set schedule. This part is working fine. What is not working is th...more >>

I have a table with a column COLOR. In trying to retrofit the SQL server table into an application built in access, I need the results of this column to be one column. The access database was designed to have the user enter Red,Blue. So for example in the SQL server table: ID COLO...more >>

Hi, I am trying to install SQL Server 2k Enterprise Edition on my PC (running XP Pro), I obtain a message error that said something like: "the component of Microsoft SQL server 2000 Enterprise edition is not compatible with your operating system" Any help?, Is it possible to install SQL...more >>

Our organization has about 10 multiuser Access databases that I'm considering migrating to SQL Server. Currently, these split databases perform reasonably well in Access over our LANs, but slow over the T1 lines. However, we occasionally run into corruption problems, and we would eventually lik...more >>

I got this error message when I try to attach a database. I don't know what to do. It says run DBCC CHECKTABLE. This database is not in the SQL yet. How can SQL check tables if it is not attached? I don't know how to do a DBCC CHECKTABLE either. I would really appreciate if anyone could ...more >>

Hi.. I am using the free version of MSSQLSERVER. How can I query or view my data? Can I do this through a GUI like ACCESS? ...more >>

Hi, I know very little about SQL Server. I have just installed the free MSDE Desktop Engine. I used the following command line: SETUP INSTANCENAME="MYDATABASE" SAPWD="<my admin pw>" /L*v OUT.LOG The LOG file generated from this is large but says that the installation was successful. ...more >>

Hi again, I've gone about a week without backing up my database (I'm a single user/admin/whatever) and thought I should do a backup, so I gave a quick look at the _Data.MDF and _Log.LDF files. Ach! The data file has grown from around 8 GB after I "shrank" it after my last backup to 19 G...more >>

Dear sir/madam, Can some body help me to enable/disable (I mean to create and drop ) trigers in sql server 2000 from the stored procedure. Regards, Ekta ...more >>

Dear sir/madam, Is there any way to run one sql server job for all the databases. regards, ekta ...more >>