Converting SQL2008 RDL file to SQL2005
How do I convert a RDL file that was created using the SQL2008 designer to work on SQL2005 Reporting services? ...
sql-server-2008
SSRS 2008 Deployment
Whenever I wish to debug a single report (.rdl file, Report Definition file), it always deploys everything in the solution. Can someone recommend a deployment strategy in order that I can localize deployment to the specific report I am working on, and not clobber the other reports in the solution? Those may have been worked on by another...
how to make DataSet return two related Tables?
Hello everyone, I am using C# + .Net 3.5 + VSTS 2008 + ADO.Net + SQL Server 2008. I have two related tables in SQL Server (foreign key relationship). And I want to load the two tables as two datatables in a dataset. Any reference code to do this? thanks in advance, George ...
ADO.Net DataReader error: Already an Open DataReader
Hello everyone, I am using C# + .Net 3.5 + VSTS 2008 + ADO.Net + SQL Server 2008. And I am sharing one single SQL Connection object (TestDBConnection variable in my below sample) within my application. The exception I met with is, "There is already an open DataReader associated with this Command which must be closed first.." Any ideas ...
SQL2008 MultiServerQuery
How i will write multiserver Query in SQL2008? ...
Multiple FKs with ON DELETE CASCADE to the same table (MSSQL2008)
I'm running into the problem described by KB321843 and this question. Both only talk about MS SQL Server 2005 (or older), while I'm running 2008. I'd really had hope that this is fixed in recent versions, but it doesn't seem like it is. Could someone confirm this (or, better tell me how I could get it to work)? ...
What permissions needed to connect to SQL Server Integration Services
I need to allow a consultant to connect to SSIS on a SQL Server 2008 box without making him a local administrator. If I add him to the local administrators group, he can connect to SSIS just fine, but it seems that I can't grant him enough permissions through SQL Server to give him these rights without being a local admin. I've added hi...
how to execute a stored procedure continuously?
I have a stored procedure that creates a database (ex: sp_createDB). In the similar fashion I have to create a 100's of databases using that one. So that I have to put it in a loop. But I don't know how to do it sqlserver. How can I do this in sqlserver. Help me in this regard. Thanks ...
How to create a stored procedure to create a database
I need the code to create the database. ...
does SQL Server 2008 supports table level readonly?
Hello everyone, Does SQL Server 2008 support table level readonly -- i.e. I can mark some table as readonly so that we could improve performance (for example, no transaction log needed for the readonly table)? thanks in advance, George ...
How can I create a SQL unique constraint based on 2 columns ?
I have a Table like this one: |UserId | ContactID | ContactName --------------------------------------- | 12456 | Ax759 | Joe Smith | 12456 | Ax760 | Mary Smith | 12458 | Ax739 | Carl Lewis | 12460 | Ax759 | Chuck Norris | 12460 | Bx759 | Bruce Lee I need to add a constraint to this table s...
A transport-level error has occurred... (Existing connection closed by the server) Sql Server 2008
I have a web application which is currently running on Windows XP operating system with SQL Server 2005 database and IIS 6.0. Now, we are trying to upgrade it to IIS 7.0 on Windows Server 2008 and SQL server 2008 database. When I run the application then it is throwing "A transport-level error has occurred when sending the request to t...
How Do You Save An Image Out of a SQL Database Into the File System Using only SQL?
Similar to this question only the other way of flow. http://stackoverflow.com/questions/416881/insert-picture-into-sql-server-2005-image-field-using-only-sql I need to be able to save a image field out into the file system and be able to name the file with only using SQL. I don't want to use TEXTCOPY either because I need to use the c...
fill factor of SQL Server 2008
Hello erveyone, I am new to SQL Server 2008 fill factor, as mentioned here in SQL Server 2008 BOL, http://msdn.microsoft.com/en-us/library/ms177459.aspx My 2 confusions, Whether fill factor applies to index page? Or applies to both index and data page? At the beginning, seems fill factor applies only to index page -- "The fill-facto...
Does SQL Server 2008 have any default mantenance plans?
Hello everyone, I am using SQL Server 2008 Enterprise version. I want to know if I do not explicitly set any maintenance jobs, are there any default maintenance jobs SQL Server will perform (like backup? rebuild index? truncate transaction log?)? Where to find the current maintenance jobs? thanks in advance, George ...
SQL Server table isolation level and lock issue
Hello everyone, For the same ADO.Net statement, I want to make sure my understanding of isolation level and lock is correct. In default SQL Server isolation level (read committed), after read each row, the row will unlocked; If I raise isolation level to repeatable read, the lock (on the whole table? or some other level lock?) will be...
SQL Server 2008 import schema and data from ADO.NET Provider?
I am trying to figure how to get SQL Server 2008 to import data using the schema from an ADO.NET Provider. You can use the Database Import wizard and choose any ADO.NET Provider (I am using VistaDB in this case). But once you go to the actual import the Copy Data from one or more tables is grayed out. You can only write queries. I wa...
SQL Server snapshot isolation level issue
Hello everyone, I am studying snapshot isolation level of SQL Server 2008 from the below link. My confusion is, http://msdn.microsoft.com/en-us/library/ms173763.aspx It is mentioned "Data modifications made by other transactions after the start of the current transaction are not visible to statements executing in the current transact...
recommend a tutorial for database type project in VSTS2008?
Hello everyone, I am interested in and new to database type project in VSTS2008. I am especially interested in how this new type of project could benefit my development work (previous I always develop all SQL stuff inside SQL Server Management Studio), and whether this type of project could facilitate deployment of database. Appreciate...
Changing default collation of a SQL Server 2008 instance
Hello, When I try to change the default collation of a SQL Server instance using this commandline: setup.exe /QUIET /ACTION=REBUILDDATABASE /INSTANCENAME=MSSQLSERVER /SAPWD=********* /SQLCOLLECTION=SQL_Latin1_General_CP1_CI_AS I get the following message: Microsoft (R) SQL Server 2008 Setup 10.00.1600.22 Copyright (c) Microsoft Corpo...