Hi,
I have an SSRS report that has 1 table with grouped data in it. It is in a list? When I run it I get 1 first page with my static title on then 67 totally blank pages, no grid outline,...
How can I see mailbox size as one the colomns in EMC similar to what exchange 2000 and 03?
I'm having a proble writing an SQL Stored Procedure to insert a value (from a text file) using VB.NET and storing that value into a table.
I want to use a Stored Procedure to pass the MAC va...
I need to copy a set of db's over to a second sql server instance and NOT have any of the security lost - if I was going to a instance on another server i would bring the system databases with...
Has anyone added a trendline to an excel chart then, set that line to forcast out a certain number of periods? The chart control in SQL Reporting Services does not have the trendline or forca...
I've been reading www.sql-server-performance.com articles on this problem, have a lot of data gathered using SQL profiler and Windows performance logs, but can not pinpoint the issue. One day...
I have a column in my SQL 2005 table that is defined as a Timestamp and I want it be populated with any new record creation.
Here's my Update code, but returns a message saying I can not upd...
Hello fellow experts. I have a new application that needs to get data from a SQL Server 2005 database. I have already linked to the tables and know what I want to get, but I really want to do ...
In SQL Server 2005 Management Studio in the Object Explorer some databases have 'Single User' next to their name and some don't. What does 'Single User' database mean?
Thanks.
I have a smalldatetime set up in the system for students, and know that I have a 20 with 28/1/2008 in the system table, if I run the procedure that retuns the information for my return then I ...
Is there anyway to out put the table structures of SQL Server tables in a database? I am trying to create a data dictonary of an existing database, but the task is pretty boring. I want to jus...
Hi,
I have a flash 8 movie that i would like to have send and recieve information from a SQL 2005 database. I am not a DBA and am not very familiar with SQL in general.
I can get flash com...
Hi,
I am trying to write the outcome of using the "power" function, against multiple record sets, into a table with each of the calculated records being the result of matching the pairs of ...
I have the following query it return two rows with values of 300 and 12 what i need to do is get the total of both Rows and display one answer.
Any help is much appreciated.
SELECT Count...
Im trying to delete records from Table A that has references to table B. I keep getting an error message about referential integrity when trying to delete all records from table B.
Could so...
if i want to be able to manually insert the value of a primary key do i want IDENTITY_INSERT to be on or off?
Is it possible to make specific rows read-only in a table?
Issues with using MSSQL Express on network. MSSQL Express has been installed onto a H:\ drive rather than under C:\program files\SQL Server... I have set tcp/ip protocols and other settings fr...
I am trying to setup a maintenance plan to do a full backup of our custom database. I go through the wizard just fine but when I go to run the maintenance plan I get the following error: Start...
The following transact SQL batch
declare @nl123 as varchar (20)
set @nl123 = '
123'
SELECT 1 WHERE @nl123 > ''
SELECT 2 WHERE @nl123 = ''
SELECT 3 WHERE @nl123 < ''
returns this
----...
SQL 2k5 on Win 2k3, fully patched. Clustering is enabled and working, but
when I attempt to log on with Surface Area Configuration app, I cannot change to the virtual server
name, when I en...
I'm developing my first application against SQL 2005 with Access 2003. I've always used cliconfg to create an alias on my development machine that connects to my development SQL-Server that ha...
Below I have the table which i use to run the following query. my query fails giving me an error message (Msg 530, Level 16, State 1, Line 1
The statement terminated. The maximum recursion 10...
Hi experts,
i have a web application residing on a web server. From that application I would like to access data stored on a DB server. When I try to connect, I get the following error:
...
I need to bind a datareader to a datagrid and some columns are dates. Since they can have #12/30/1899# as the empty value, I want those converted to an empty string so nothing is displayed in...
