Hello Experts,
I have a very large Database (20,000+ records) which has time Columns (among others).
Time_1 and Time_2 have been entered with VarChar formatting. A time of 2:15 PM would b...
There is a SQL Server 2005 database that I need to connect with. I can personally connect just fine, since ALL users are connected using WINDOWS AUTHENTICATION. But a new Active Directory us...
I am trying to load MS Dynamics CRM 4.0 Workgroup server onto a MS Windows Server 2008 using MS SQL Server 2005 Standard SP2.
towards the end of the install i get the following error:
Se...
Hey all,
I've got a systems that is already in place that runs 3 HP blades (Dual Quad Core Xeon / 16GB memory), Windows 2003 R2 Enterprise, and SQL Server Standard 2005 SP2. All software i...
I'm getting this error on one of my servers in the Event Log every day.
Event ID: 107
Source: Report Server Windows
Report Server Windows Service (MSSQLSERVER) cannot connect to the rep...
Hi
I am writing a stored procedure and i need the value from a query as the following :
select count(*) from (select......)
So the number here i need it to be affected to a variable : @...
I have a user I need to drop from a SQL database. he shows up as owning the dbo schema. I need to transfer this to another user account so I can delete the user but I get an error saying:
Can...
Create a new instance on ms sql server 2005
In a table, there is a field called UserDefined1 of the type VARCHAR(100)
I'm using it to store numeric values... there are 10k+ records and I suspect there are other than numeric values in...
Hi,
I am dealing with the a table to keep the services within a start and end time.
Every time i create t a service i want to assigned the end date with maximum possible value..
is the...
Experts,
I'm trying to learn the basics of SQL Server Reporting Services 2005. I have a book. The book uses Business Intelligence Development Studio. I have reporting services installed ...
How to split string in sql server 2005 using character? I want to use every part of splitted string.
There is split function available in VB or VB.NET, but how can i do this in Transact-sql.
I want my result set in SQL to be selected on a specified date. So my storedproc has specifiedDate parameter which is of type NVARCHAR, and I convert my datetime colum to a NVARCHAR with the f...
T-SQL - Update Trigger
How can I check which fields have been updated from their original value and what has it changed into
I.e.: I am monitoring 10 fields in a table... when an update ...
Im running Windows Vista Home Premium edition
Im trying to connect to my sql server 2005 express database using sqlserver management express. The problem is connecting using sqlserver authe...
We have a Microsoft SQL server 2005 sp2 that is running software called MRM. The ldf file is growing and is now 8.5 gigs. At random times during the day the software stops responding. After...
Hi Experts,
Problem: I can't connect to Sql Server Reporting Services SSRS from Sql Server Management Studio and connect access the Report website.
Background:
I originally installed Sq...
Hi,
I have several databases which are having same tables and table structures, but recently we have made several changes to one main database tables. Now I want to compare the tables from ma...
Hi, I need some help here, all this while this code runs perfect until recently it will fails sometimes by throwing the error "Error converting data type varchar to numeric", I can't figure ou...
Is is possible to pass more than 1 input/output paramater to a stored procedure from within another stored procedure?
I want to pass in parameters into a stored proc lets say X = 5, Y= 10, ...
I need to update a sql table automatically from multiple text files. The text files are created from a proprietary program and saved into a directory on our server. The files have the same col...
I'm being tortured by what seems like ridiculous complexity in the security setup for reporting services 2005. I've installed it locally on an XP professional machine with SQL Server 2005 stan...
I have problem to print in the SQL Reporting. When I click on the print control, error message "Unable to load client print control" popup. I cannot print anywhere except in the SQL reporting ...
Update KB948109 is failing to install. When this happen, it cause the virtual server to stop working with this error in the application log:
Event Type: Error
Event Source: MsiInstaller
...
