I'm trying to setup Report Server but have the following problem:
The permissions granted to user XXX are insufficient for performing this operation. (rsAccessDenied)
The report server s...
Hello, I have a database that I incorrectly configured using a collation of SQL_LATIN_GENERAL1_CS_AS. Can someone please tell me how to change the collation to SQL_LATIN_GENERAL1_CI_AS? I ne...
Can someone provide step by step instructions on how to schedule SQL Server 2005 SSIS packages without the sysadmin role? We have developers that are unable to successfully schedule their SSIS...
This question is regarding SSIS:
I am trying to loop through a directory of directories that contain directories which contain files. i.e:
C:\databases\client1\client1.mdb
C:\databases\cl...
I am trying to install SQL 2005. As far as I know I have completely uninstalled all previous versions of SQL Server. I am able to install all components except the "Workstation Components, B...
I'm looking to import two select statements union'ed together that is using a distinct to get unique records:
select * into cpv2649 from
select distinct keyword from
(select keyword from ...
Hi, I'd like to confirm this is the correct way to connect to a SQL 2005 database through VB.Net. This client is using the default instance of local for their SQL Server 2005 instance on a ma...
if i have a dynamic sql query something like this
set @strsql = 'select @somevar = somecolumn from ' + @tablename + 'where condition '
exec @strsql
it does not populate the @somevar vari...
I know this is an easy one and I have seen the solution before but I'm tired and can't figure it out.
I am getting an error
Conversion failed when converting the varchar value '../image/...
I'm trying to restore a back up database into sql server 2005. And I'm having an error message says;
"Too many backup devices specified for backup or restore; only 64 are allowed. restore dat...
Is there a way to change the system databases collation from Latin1_General to SQL_Latin1_General_CP1_CI_AS without having to re-install? If so, how?
A quote from http://classicasp.aspfaq.com/general/why-does-4/5-0.html:
"Why does 4 / 5 = 0?
SQL Server
You may be startled to see the result of this calculation in SQL Server:
SELE...
Hi,
I am making a report using Reporting Services with Microsft SQL Server 2005 (through Visual Studio). I need to display some numbers, but they default to numbers like: 10000.00. The targ...
I have the following query which counts up values for all organisation for a specified year. The problem is the BudgetProfile = 0. Some of the organisations values have changed but the old v...
I would like to merge a field in multiple rows, into 1 field.
Example:
from:
1 | Test | Information |
2 | Sample | Information |
3 | Demo | Information |
into:
0 | Test, Sample, Dem...
HI there,
I have a system that was upgrade from XP to Vista Business 32 bit.
I am trying to install SQL 2005 Express with the Advanced Tools.
The PC meets all the requirements finds a...
Unable to complete SQL 2005 SP2 installation on Windows Server 2003 SP1 Cluster. Some components failing including SQL Server and Client Tools. Log attached below:
Ran install using domain ad...
hi
in ms sql server 2005
i want to create and ms sql user only has execute permission to stored procedures ?
any idea how to set this thing ?
Hey everyone,
I'm using SQL Studio 2005 and want to export the queries I run in the Analizer to Excel...including the column headers.
Do I set that in the options somewhere or code it?...
IN MS Access I have a query to get time
AS
SELECT Now()-[intake_dt] AS [Time] FROM Table
How do I do that in SQLServer 2005
Hi,
This is a very basic question. I have a SQL Server 2005 server and have successfully created a dblink to a SQL Server 2000 server. In SSMS I can see all the tables on the 2000 server, but...
I am working on a stored proc to convert the comma delimiter to pipe delimiter. I noticed that any delimiter was not given at all the the code. So now I am adding another SELECT on the top of ...
I have the following:
EXEC msdb.dbo.sp_send_dbmail
@recipients=N'email@address',
@body='None',
@subject ='Subject',
@body_format = 'HTML',
@profile_name = 'Profile',
@query ='set noc...
I have a BirthDate Column which contains values such as 10/5/1960 12:00:00 AM and some records are NULL because there are employees like Temps where we do not track birthdays. I have a column ...
I have installed SQL Server 2005 some months ago and have been using to connect to a remote instance without any problems.
Now I'm needing to create a local database in my localhost (like I...
