Hello,
I am trying to execute a stored procedure from a VB6 application - get an error message telling me thta execute permission is denied.
Have read elsewhere on this site that I need ...
OK, we copied a working ASP.Net 2.0 App from a machine running IIS 5.1 under WinXP to a machine running IIS 7 under Win7. We Get: Login failed for user 'IIS APPPOOL\DefaultAppPool'.
at line...
After SP 4 installation on MS SQL 7.0 I found problems with clients (ODBC) connectivity. Connection using Name Pipes works fine, but TCP/IP connection fails. The error message on clients is SQ...
Hi Experts
I have a SP that creates a varchar(200) string that creates from a table entry such as (A+(0.75*B)) a string such as (0.093000000000+(0.75*0.004087939911))
I now need to evalu...
Hi Every Body
I am using Access in order to develop my Forms and Reports and my database is a SQL Server, I am trying to insert Data from a form that I have made to a Table in my database whi...
Is there such thing as a foreach statement in TSQL? or is a cursor the only option here?
I want to itterate through a small result set and it would be nice to have something more susinct th...
Hi all, i keep getting this error message when I try to add a new item into my database
Cannot insert explicit value for identity column in table 'MenuItem' when IDENTITY_INSERT is set to O...
I am trying to convert a date (in milliseconds) to Date Time format from 1/1/1970
I am already able to convert the current date/time into milliseconds using this code (snippet):
But I ...
Hello - my computer has crashed so I had to re-install the complete system incl sql server 2005 and tried to restore a mdf database file from a backup. Unfortunately, this is only a copied mdf...
my user data log is reaching 11GB. I need to shrink the log file. Because of lack of hard drive space, I added a new hard drive and move both user_data.mdf and user_log.ldf file from C drive ...
Hi,
While restoring the SQL serverdatabase, I obtain the following error:
Microsoft SQL DMO(ODBC: SQLstate 42000):
The backup of the system database on devise XXXX cannot be restored ...
Hello,
Can someone tell me where to download the client side activex control for the print button that was added with the new service pack?
Some pcs prompt for it automaticly, but others...
Hi
When I type the following in SQL Query Analyzer
SELECT DATEPART(ww,GETDATE())
Result: 45
But the actual week number is 44
Is there anyways to fix this - since some years ...
We have a few servers running ms sql 2000 and one server that runs ms sql 2005
I have created multiple linked servers from one ms sql2000 server to another and they have worked fine
I am...
Hi,
The log file will not shrink in size.
I used the following commend (to no avail):
CHECKPOINT
GO
DBCC shrinkfile('DBNAME', 1)
GO
BACKUP LOG CAM WITH TRUNCATE_ONLY
GO...
How do I change the value of an identity column for a record?
I am trying to do something like the following, where ID is an identity column.
UPDATE COMPANY SET ID = 7 WHERE ID = 6
Hi,
I'm quite urgently needing an SQL statement which removes the primary key constraint from a column while leaving the data intact.
Can't quite make heads or tails of the MSSQL syntax ...
I need an SQL (SQL Server 2005) script that can drop one or more columns in a table if they exist. Below is the script I have in place that is not working.
if exists ( select * from INFORM...
I have Microsoft SQL Server 2005 Express Edition with Advanced Services SP 2 on my server and want to upgrade to Microsoft SQL Server 2005 Express Edition with Advanced Services SP 3. I have t...
HI,
I am getting this error when trying to restore and not sure why:
---------------------------
Microsoft SQL-DMO (ODBC SQLState: 42000)
---------------------------
The media family ...
When I issue this statement i get the following error
ALTER TABLE "Archived Greyhounds"
ALTER COLUMN "Whelp Date" DATETIME
GO
Server: Msg 8115, Level 16, State 2, Line 1
Arithmetic ov...
when i write Store Procedure
use by Linked Server Connection
CREATE PROCEDURE MyProc as
Select * from [LinkedServer].DBname.dbo.Mytable
go
when app...
This morning system performance was degrading as the number of the system processes was exploding. Normally I have about 20 processes running on a database (master..sysprocesses), but in one h...
I've been tasked with moving a bunch of code from dynamic SQL to stored procedures and I've run into a bit of a problem with a search function. The nasty little bit of code in question genera...
I want to insert values and fields into a table, is that possible? Here is how I started:
INSERT INTO dbo.tblNonMon_Daily_Trans (PCRACT, Transaction_Code, SubTrans,
Term_id, Op_Code...
