Search results for query: *

I have a table with out a primary key. I want to copy this table's data/structure into a new table with a primary key (with auto increment attribute). What code can I add on to this to acheive this? Will it assign id's to the current data? select * into NEW_TABLE from OLD_TABLE

Hi, Does CF limit the amount of characters (text) you can insert into a SQL database field with data type "text?" Microsoft says it can do up to 2GB. My data keeps getting truncated when I try and insert a big text document via a form.

What is maximum character count for SQL field with data type text or ntext? I'm trying to copy and paste a 63,000 character/39000 Bytes Word document and upload into the database via a form. It keeps truncating. Do you know what the maximum amount allowed is? Do I need to change some settings?

Hello, I'm having trouble connecting/registering a sql server over a VPN. During the SQL Server Enterprise Manager wizard registration process, I enter in the IP address of the server running sql and get the following error: SQL server does not exist or access denied.|ConnectionOpen(Connect()...

I've tried putting in a username and pass and i still get the same error

Hello, I connect to my company's LAN through a VPN. We have SQL Sever running on our LAN server. I'd like to connect to it through SQL Manager but when I try and register the SQL server i get the following error Login failer for user '(null or any username i put)'. Not associated with a...

Hi, Unfortunately, I have a field in a database that is labeled state_province. It contains state abbreviations such as NY for New York. It also contains Provinces like Alberta. How can you arrange that data when i select it? I'd like to have all the US states at the top of my list in...

Terry, If i get the appropriate permissions from the sys admin, will it let me copy the database down exactly? Why won't my local database read tables of another owner?

My situation: I want to copy down the tables and data from our "Live" SQL server to our local copy of the database. My problem: We don't have sys admin privileges on our "Live Server". When I use the SQL import/export wizard the data will copy over correctly but not the...