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 ...
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 found this script to check if a column exist in a table and to create the col if not exisiting:
IF NOT EXISTS (SELECT TABLE_NAME,COLUMN_NAME
FROM master.dbo.INFO...
i have an important database that was hosted from a server in a datacenter, we were having problems with the machine so sql on it was backup up and it was reformatted. When we got it back onli...
Is it possible to downgrade a SQL 2008 database so that is can be restored in 2005?
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...
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 ...
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 ...
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...
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 ...
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
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...
I am trying to rotate 186 columns into rows. For eg, what I have is like this:
product date1 date2 date3
A 100 100 200
B 200 200 ...
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...
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...
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...
This is a easy one (Can't for the life of me figure it out)
I want to convert a number to a string by rounding to one decimal place and and then appending a '%' to it, so for example 17.547...
Hi..
I have a big problem, hope that you can help...
I have windows 2003 server with CA brightstor 11.0 (Build 2670)
and is making backup to all my SQL Servers.
so I need to restor...
when i write Store Procedure
use by Linked Server Connection
CREATE PROCEDURE MyProc as
Select * from [LinkedServer].DBname.dbo.Mytable
go
when app...
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...
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...
HI,
I am getting this error when trying to restore and not sure why:
---------------------------
Microsoft SQL-DMO (ODBC SQLState: 42000)
---------------------------
The media family ...
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...
