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 ...
Why won´t this work?
"Microsoft OLE DB Provider for SQL Server (0x80040E57)
String or binary data would be truncated."
To me it appears that it wont convert the Date to VarChar Datatype....
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...
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 ...
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...
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 ...
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 ...
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
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...
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...
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...
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...
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...
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...
possible or impossible?
we have a database which previously was understood to have backups on it through the inception of the server. we found out today after having dropped tables that th...
Hi All,
I have an old MSSQL 2000 installation from a previous admin setup here and no one has the SA password. Does anyone know of any utilities to extract/find the SA password, or am I SOL?
A user has been trying to print a report from a website and she gets a "unable to load client print control" error message.
We are operating in a SQL 2000 environment. We are running Windo...
I applied SP2 on Win2003 Server for the SQL 2005 Standard.
Why do I get
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corpo...
