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...
Create a new instance on ms sql server 2005
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...
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...
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.
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...
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...
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...
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 ...
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...
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 am trying to change the listening port on SQL 2005 from the default of 1433 to 2433. How do i go about doing this? sone things that i have tried do not work. Thanks
Dear DB Experts
- I have a file with .DBF format; how can I know which database is this??
Is it Microsoft database 5 or which version
Or FoxPro???
- I managed to open the file with a u...
Can someone make this work:
The procedure checks if a record exists in a table, if so then update a counter, if it doesn't exist create new record
table structure:
[dbo].[tbl_trackAd...
What do I lose by choosing to use SQL Server 2005 Express as my database versus SQL Server 2005 Standard?
I know that it's limited to 1 CPU and 1gig of RAM (my database is 19megs, expected ...
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
...
One of our clients servers is unable to Start the SQL Server Reporting Services Service. I know very little about SQL but here are the error messages:
"Could not Start the SQL Server Repor...
How do I grant stored procedure execute permissions to a domain security group without having to create individual users for each user on the SQL server?
SQL 2005 (mixed authentication)
W...
Hi,
I am trying to restore my master database to a different server but I get the following error message:
C:\> sqlcmd
1> RESTORE DATABASE master FROM DISK = 'C:\Installation Files\MSSQ...
Currently I am the only person in our org that has access to SQL server. I need to add one more person to be able to have read only access. I am looking for them to just be able to run queri...
How to decrease the size of log file for existing database in sql server 2005?
