Hi all,
I'm putting together a report that has a list of rooms and their square footage. I'd like to set it up so that what I'm returning to the user is the Building's name in the Group Fo...
Hi again..today's problem comes from trying to assign a couple of variables based on the value of another variable. In this instance, the variable @RetailWeek is passed to the procedure which ...
Super Rookie Question. How do I import a csv or pipe delimited file into SQL SERVER MANAGEMENT STUDIO? I have a csv with 1 million plus records I need to import. I am not a database guy and...
I've got a db whose trc files have grown too large. What are these? How can I get rid of them? And how can I control the growth?
How can i check the length of a sql column value.
Here is what i need
ID, QUESTION, PROCESSED
1,'abc', 1
2, 'abcd',1
3,'d',2
I wish to query the table and retrieve only rows where ...
I have a report with two parameters with default values that runs automatically. I want to disable this autorun so that the user has the option to change the parameters before running the repo...
I am trying to use the Sage ODBC driver to return information to SQL Server 2005. I have got the following to work on a x86 machine.
1.) Created a SageLine50v14 System data source in ODBC D...
I'm getting the following error when I try to access the http://localhost/Reports/ and http://localhost/reportserver/ web pages on SQL Server 2005 Reporting Services (running on Vista Ultimate...
Greetings Experts!
I have a question, it may sound very premitive, but I still consider my self all new to SQL SERVER. My question is, What is the port number used by SQL SERVER 2005 to conne...
I am trying to import data from a file using BULK INSERT by calling it from my application. I need to monitor its progress and show the progress bar while importing.
Is there any way I can ...
Finished installing Windows 2003 64bit Enterprise SP2, cluster and I am following the standard tests for cluster failures. I was able to successfully do the Moving Groups test via Cluster A...
I have a stored procedure that does a search on a customer table. I display the result set in a Gridview on an ASP.net page. If no where clause is set the query could return 50k+ records. The ...
Simple one here, I've got two fields, lotSize (decimal 18,2) and lotSizeType (varchar(50)), which store things like 2.34 + Acres, or 12345 Square Feet. I've got an SP where I want to get the E...
So here is the problem I am running into. I have a txt file that was exported from another database that has over 5 million records and over 50 columns. I am using the SQL 2005 Import wizard...
I'm trying to SHRINK a pretty big database
390gb disk space
but when i try to SHRINK it using "MS SQL server managament studio"
i get this error :
-------------------------
Impossibi...
I would like to convert a UTC datetime value to any Local Time Zone. Is there any suggested approach or code available?
Thanks
I'm developing a report which shows a count by day and by hour along with a daily total and a weekly total after every Sunday. The attachment shows an example of what the result should look l...
Below is a proc that I have. after executing it I get 2 rows of XML. I want to loop through each row and perform some tasks on it. How can I loop through different rows in SQL server store proc
Hi
i need help in sending mail using ssis.
i need to run Stored procedures or Sql Queries in Sql
and get the results into Excel sheets and send e-mail to different people.
i want to use ...
Using SQL 2005 Reporting Services. We are getting the following error in the Reporting Services Configuration:
ReportServicesConfigUI.WMIProvider.WMIProviderException: A virtual directory ...
hello
I have table as folowwing
Create table mytable
(id int identity primary key
, fld1 nvarchar (10)
)
I have Stored Proc. as folowwing
create procedure insert_mytable
(@fld1 nvarch...
We upgraded to SQL 2005 from 2000 and now have a problem remapping 2 DB tables to UPS Worldship 10.0. SQL 2005 server is supposedly supported. I have recreated the user 'UPS' with a login in S...
Hi,
I am working in integration services SSIS. I have the following issue: I have to write an SSIS job which can be scheduled to run at a specific time.
It needs to run these two q...
Client gave me a backup of their sql 2005 database.
I want to restore it in my sql 2005 EXPRESS edition on my laptop . So i created an empty database and tried to restore it on the new-empt...
Hi,
I'm having a problem with DTS and wait types that seems to be baffling me at the moment.
I am using DTS on a SQL Server 2005 database (yes I know but thats the only option I have atm...
