Does anyone know a fix to this problem?
Cannot insert the value NULL into column 'AppId', table 'tempdb.dbo.ASPStateTempApplications'; column does not allow nulls. INSERT fails. The stateme...
I need to truncate a table, but first I must delete all foreign keys and indexes.
Is there an easy way to drop/recreate these keys and indexes. Can I produce a script that "remembers" the...
As I'm still new to SQL Server, I'd like to know how to dedupe a table. I used to do it all the time in Access by simply copying the table structure and then indexing the field that contains t...
I made the following module to find the tables and the columns with a text I want to find with.
Help me please.
declare @keyword varchar(50)
set @keyword = 'My Text'
if exists (selec...
Hi,
Simple question. Is it possible to do a raise warning in a trigger? Ie show a message but let the user continue as opposed to raise error which stops the user from continuing? If so ...
I know how to SET IDENTITY_INSERT On and Off. How do I determine if it is currently On or Off?
I apologize for being vague in my question, but I am at a loss for where the problem lies. Here is the situation:
I have an ASP website which connects to a back end SQL Server 2000 databas...
Hello, How can i have sql 7.0 automatically assign a datestamp (or time & date stamp) to a field in a table when data is added to the row?? also assuming that this can be done, does the datest...
Hi
I am trying to set up a job on SQL server, however I am getting the message 'Could not find stored procedure master.dbo.xp_regread' when trying to create a new job.
Can anyone advise ...
What is working in a CLUSTERED environment? Or CLUSTERING? Where can I learn this?
I'm trying to duplicate a record which is fine, but i want to hardcode one of the new field values rather th. Here's the code which isn't working:
Set NoCount On
INSERT INTO myTbl (val1, ...
hi all
i have a field which is stored as a varchar(30). I need it as varchar as the value can be characters or numbers etc.
in some case i need to add two of these fields when the tex...
Hi all,
Im desperately trying to convert a hex value into either an int or big int.
The snag is that the hex number is bulk inserted and the sourcefile does not stipulate 0x infront of t...
I know that SQL Server does not support CrossTab queries
What I dont know is how to get around it.
Here is the SQL I need to convert.
TRANSFORM Count(vw_POS_LOC_DFLT_REM.PM_EmpAssigne...
Hello everyone,
I've got a little problem with the Full-Text Search (MSSearch).
If I try to create a ft-catalog trough Enterprise Manager, nothing happens - it populates and populates - no...
Dear All,
We can use following command in Oracle SQL:
CREATE TABLE tblA SELECT * FROM tblB WHERE 1=2
Using above statement, we can copy a table structure in Oracle. But we can't run the...
I have a SQL database and I store all the information on that. I want this database to be accessed from pocket pc's. For this reason I had to convert all my database to a *.sdf file format so ...
I have a re acurring problem with a Sql 2000 database, for some unknown reason the temp database explodes and fills up the disk, subsequently on the same partition the user database backup fai...
I use OpenRowSet to manually synchronize some big tables of our development server (from the production server).
For that purpose, I am trying to build a query and pass it to the OpenRowSe...
Background:
I recently moved a database (via detach and attach) from a local drive on the db server to a SAN drive. The detach and attach were successful and the table counts afterward match...
Hi friends,
When I run "EXEC xp_startmail", I get the following error:
"xp_startmail: Either there is no default mail client or the current mail client cannot fulfill the messaging reque...
Our server name was changed on the domain after SQL 6.5, the databases, scheduled tasks, etc. were created. Everything in SQL works fine, except the server name is still shown as the old name...
Is there a way to get sql to return the starting day for a week number? Ex: When datepart returns week 2 can I get it to return Jan 6,2002
I would like to create SQL programs in MS Notepad and then run them by opening them(and the Database itself) in an MS-DOS/C-prompt window.
I would also like to pipe the query results to a s...
hi! i am trying to use a variable in a TSQL string.
In the first select statement i find the name of the 7th column of table alerts.
I retrieve the name(which is called 'Sol') using a curs...
