Hello
I can not create a new database using VS2005 with SQL EXPRESS 2005 although I am the administrator and only user. In the SQL server surface area configuration window there is no optio...
How to execute logic against an excel data source with SSIS 2005
I get a file from HR weekly. This file contains HIRE and TERM dates. Unfortunately all the dates are in 1 column and they ar...
Hi experts could you please guide me me answering me about Monitoring of SQL Server 2005 ,
what login is the best shall i ask for Dedicated Server login or SQL Client login.
This login would...
I'm using the OleDbDataAdapter.Fill command to fill the tables in the dataset with the tables from the Northwind Access database and I want to recreate the same database in my SQL Server. What...
I have an Access form connected to SQL Server. After update on SequenceNo I want to run a statement using SQL that checks to see if
a record with matching Fields for Facility(which would al...
I would like to find a way to convert Access SQL to SQL Server 2005 syntax. I currently have a SharePoint site that uses GridView boxes that displays data using SQL stored procedures but at th...
Hi there,
I have a rather complex problem to resolve and I would like a view from fellow experts. I am building a web application which will allow the user to view a report and save the vie...
Hello guys
Is there any command in SQL that could return all the fields from a table that null is not allowed?
Thansk
I have a simple table, no grouping. In the footer I summarize each column. The only column that does not come out correctly is the last:
It is an expression:
= RunningValue(Fields!Total...
I am creating a DotNetNuke module where I have wrapped the SQL ReportViewer. I have got the module working when logged in as the host account. When I try to load the report viewer as any oth...
Dear Experts:
i am a DBA and i would like to set up a new database mirorring (SQL 2005) for a number of our critical databases accross the country ,i would like to use the high availability o...
hi,
I have the following select statement:
SELECT FOLIO_NUMBER
,NAME_LINE_1
,NAME_LINE_2
,ADDRESS_LINE_1
,ADDRESS_LINE_2
,LEGAL_LINE_1
,LEGAL_LINE_2
,LEGAL_LINE_3
,LEGAL_LINE_4
...
The table field value shows Text 16, the errors shows it occured on row 1376, I dispayed the table but it is not I don't see a record number. I am not an expert using query or sql but I can ma...
hi,
i have a select statement that is creating a column but once it reach certain amount of charaters it stops and it generates the rest of it. How can i fix this?
here is the select statem...
Hi, I have this Stored Procedure with 2 Parameters for Date Range. Users enter this Date Range for Current Pay Period [For Example - From 05/01/2008 to 05/20/2008]. When this Date Range is ent...
Greetings:
I have the code below that works for a particular server refered to as 'POINTER_TO_SERVER'
I made a local backup of the database located on that server and ran the same code b...
I have got a time value in integer format: 143000.
I want to split this value and get 14 in a variable name hour, 30 in a variable named min and 00 in a variable named sec.
How is this done ...
If you had several thousand customers running your app against an MDB and you wanted to convert their databases to SQL Server, how would you do it?
We can code the upgrade but there will be...
Why would i suddenly be getting an error when trying to delete something from a SQL database via an ASP.NET page?
Exception Details: System.Data.SqlClient.SqlException: The DELETE statement...
I am using the following SQL code as the Value for my date field in a report using Business Intelligence Development Studio.
=Parameters!TimeIn.Value & Parameters!TimeOut.Value
When I e...
Hello there, I am new to the sql world, and am in need of some assistance. I have a customer that is running an sql server at there location, and I need to pull data from a table located on t...
Hi Experts,
I have a SP that I runs several other SPs as part of a Morning Batch Job.
The first SP doesn't appear to run correctly.
I would like to add "GO" statement after each EXEC sp...
Hello experts!
I will create Windows Form application with .Net 2.0 that log to SQL server 2005. I will NOT use integrated security, i.e I will use mixed login - user name and password. So ...
I have SQL Server 2005 Reporting services (Developer edition) installed on a machine with Windows Server 2003 std, where my database is also installed. The database was sql server 2000 and i ...
I am a first time installer of SSRS but my buddy who has done it several times walked me through it yesterday and its still not working correctly and I need this up and running correctly ASAP....
