How to Learn MS SQL Server 2005?
I would like to start learning SQL Server 2005 on my own. Can anyone recommend good books or websites that will be a good start for me? ...
sql-server-2005
Problem with an Access 2007 Project connecting to Sql Server 2005
So I've created an Access Project for one of my users so he can connect to a reporting database. The .adp project connects to the DB and he can query data to his heart's content. The problem is, no queries can be saved. Whenever he opens the project, he is presented with the following error: "This version of Microsoft Access does not...
sync SQL Server 2005 login passwords
Background: We are running a web application where each user has a login to the system. The application login is mapped to an actual SQL Server 2005 login (which we needed to create). Our development and disaster recovery sites are simply copies of this setup. On a nightly basis, the production database is backed up, the dump is archi...
NHibernate: Freeing .mdf file
Hello, I'm using NHibernate for a project. This project opens a SQL Server 2005 database and then, after all work is done, It's supposed to backup the database. The problem is that SQL Server keeps the handle open after calling factory.Close(), so the backup copy fails. How do I close the file handle? Thanks in advance. ...
SQL Server 2005: Transaction Deadlock
Hi ppl, I am getting this error very frequently but not consistently on 2 pages in an application which is in a production environment. I just have some screen shots of the error below. Transaction(Process ID XX) was deadlocked on lock | communication buffer resources with another process and has been chosen as a deadlock victim. Reru...
DTS Packages Failing in SQL Server 2005
I am getting the following error when my DTS package is scheduled: Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER I am not sure how to get my DTS packages to execute. They run fine when I manually execute them I am running SQL Server 2005. DTS Packages were created using the Import/Export Wizard. ...
Exporting/Importing Stored Procedures between DBs
I have two SQL Server 2005 databases, one is for development and the other is on the final production server. I would like to know the fastest way of ensuring that the production database has the exact same stored procedures (number and most recent version). Assumptions: Databases have same table schema. Production database is curren...
Changing multiple foreign keys to point to a new table
On MS SQL Server 2005, I have a table that I want to replace. Many other tables have a Foreign Key reference to this table. Is there a script that I can run to simply roll over all these references from the old table to the new table? Or am I going to have to go through and specifically drop each of these foreign keys, and write a new...
SQL Server 2005: Determine datatype of variable
Is it possible to determine the type of a local variable at runtime in TSQL? For example, say I wanted to do something along these lines: IF ( @value IS INTEGER ) Or IF ( TYPEOF(@value) = <whatever> ) Does anyone know of any way to accomplish this? EDIT: This is not for a specific task, this is more of a general knowledge questio...
How can I use transactions that span procedures chained across multiple servers?
I'm trying to test a proposition that one of our vendors presented to us for accessing their product database and it regards to queries and transactions that span multiple servers. I've never done this directly on the database before and to be frank, I'm clueless, so I'm trying to mock up a proof that this works at least conceptually. ...
Can I add sub folders to a SQL Server Management Studio Project?
What is the best way to keep large projects organized with SSMS? I want to do something like: ProjectRoot SchemaObjects Tables Constraints Indexes Keys Functions Views Stored Procedures Scripts DataGeneration And so on, but I cannot find a nice way ...
SSRS Report Builder 2.0 - Use with SQL 2005
I'm starting to look into SSRS Report Builder 2.0, and I see in the documentation that it supports connections to SQL 2005. Does anyone know if the reports made against SQL 2005 can then be upload to the SSRS 2005 website and ran from the site? Or, can they only be run from the SSRS 2008 website if they were generated in Report Builder...
Closest match for Full Text Search
Hello, I am trying to implement an internal search for my website that can point users in the right direction in case the mistype a word, something like the did you mean : in google search. Does anybody have an idea how such a search can be done? How can we establish the relevance of the word or the phrase we assume the user intended t...
Can you import a SQL file into a SQL 2005/8 script?
Hi If I have scripts in multiple files, and I would like to execute each one in a known sequence, can I simply import them into a T-SQL script and execute them, or must I run sqlcmd or similar against each file? I'm sure Oracle has a feature to import/include script content from another file (maybe with @@ ?). I want all of the scripts...
Point to localhost\sqlexpress using only localhost
Working on a common codebase, one developer is running SQL Server Express 2005 and the other 2 are running SQL Server 2005. Everything is working fine, but the connection strings differ. To maintain common configuration and build scripts we're looking to mask "localhost\sqlexpress" to just "localhost" like the other 2 developers. Can th...
Executing a manual failover (no witness, high protection mode)
Not really my area of expertise, so I am a bit stuck... I can execute a failover if both the primary and the mirror partners are available, but I can't figure out how to do a manual failover when the principal is switched off or unplugged from the network (ie fails). I tried using: ALTER DATABASE myMirrorDatabase SET PARTNER FORCE_SER...
Visaul C++ 2005 hangs during qt builds
At my shop, the main product app is a mongrel built on MFC, QT and other random things devs have thrown in over the years. In the current stack, Qt toolkit is on the way out, but still features heavily. If I have SQL 2005 Management studio open and have to do a full build, it usually hangs a CPU (even after the offending process is take...
Sql Server Reporting Service without Full SQL Server
I am going to use SSRS to generate report for my website. Scenario: I have 2 servers, Application server & Database Server. I want to have reports(.rdl files) sitting on Application server(IIS) accessing data on SQL server(Database Server) In order to fulfil these requirement I require to install SQL server 2k5 on my Application serve...
How do I configure authentication between linked servers?
I am trying to test a proof of concept that I can run a distributed transaction across two linked SQL Servers, linked using sp_addlinkedserver - their names are Server1 and Server2, both running under default instances. Each server holds a single database, Source and Destination respectively and the destination database holds a single t...
Simulating group_concat MySQL function in MS SQL Server 2005?
Hello everyone. So I'm trying to migrate a MySQL-based app over to MS Sql Server 2005 (not by choice, but that's life). In the original app, we used almost entirely ANSI-SQL compliant statements, with one significant exception -- we used MySQL's group_concat function fairly frequently. group_concat, by the way, does this: given a tabl...