I have a bunch of SQL servers which I periodically performs maintainance on (Windows Update patches etc.). Now I want to the database online 24/7 and need to implement one of the high-availability solutions for SQL server. The solutions needs to be cheap and simple to use. I have no problems tweaking the connection strings for the clien...
I love the new DATE datatype in SQL Server 2008, but when I compare a DATE field to a DATETIME field on a linked server (SQL 2005, in this case), like this: DECLARE @MyDate DATE SET @MyDate = CONVERT(DATE, GETDATE()) SELECT * FROM MySQL2005LinkedServer.SomeDB.dbo.SomeTable WHERE SomeDatetimeField < @MyDate I get this error: OLE D...
Hello, I have a Money column in my SQL Server 2008 table. In my below query how can I round it to nearest 5$ select FineAmount from tickets Thanks ...
I need to localize data in tables in a SQL Server 2008 database. Each language will need its own sort order when selecting records. I was told in another thread that creating separate tables for each language would make it nearly impossible to create the select statement in a Stored Proc. to return the records for a culture. However, ...
While altering a table (removing a column) in SQL Server 2008, I clicked the Generate Change Script button and I noticed that the change script it generated drops the column, says "go" and then runs an additional ALTER TABLE statement that appears to set the lock escapation for the table to "TABLE". Example: ALTER TABLE dbo.Contract SET...
Hi there, i am dealing with some legacy access < 2007 "databases". All the tables are linked tables to a SQL Server 2008. While the odbc-links are established the table structure is copied into the mdb-file together with the DSN-string. Thats what one can see in Msysobjects. A query forces the jet-engine to retrieve the data from SQL...
Hi, I am developing an application which needs to backup data between SQL Express 2005 and SQL Server 2008. My client runs with an installation of SQL express 2005 and needs to periodically back up data to a server database running on SQL Server 2008. The client db also receives some new data from server and needs to update itself. The ...
Hello, Yesterday I asked the question on how I should save my files. After some research I've desided to go with storing the files "in" the database. I've checked the difference between storing the files using filestream and storing the files in the database itself. Each has it's advantages and disadvantages. To help me with my resear...
Has anyone any experience moving a number of identical SQL Server databases (with unique data) from individual local servers to a single internet based server? We currently have 10 companies using our Windows app which uses SQL Server 2008 for data storage, but we are finding that maintaining the databases and ensuring they are backed u...
Anyone know any a few good references for getting familiar with the SQL Server 2008 Database projects? I am getting a bit overwhelmed and would love to find a walk through for putting this project type to good use. Thanks in advance. ...
I have a trigger where I want to send out an email on updates to a row in a table SalesClosing. Now the user (dbuser) who execute the trigger has very limited permissions. So I want the trigger to execute as dbmailuser. A user who has rights to send out email. I tested that dbmailuser can execute sp_send_dbmail when logged in as that use...
Everytime a stored proc is ALTERed or CREATEd, I want to capture that in a trigger to do some stuff afterwards. Can I do that in SQL Server 2008? Thank you. --Beemer ...
Does anybody have an idea why SubSonic 2.2 SubSonic.SqlQuery object would be generating very different sql for the same C# code when running against SQL Server 2005 or SQL Server 2008? I have a site that's been running for a while on SubSonic 2.2/SQL Server 2005. I just upgraded the DB to mssql 2008 and am encountering the following er...
I am trying to compute Mode along with a bunch of other aggregates (SUm,Min,StdDev) on a report. Currently there is a Row Group and a Column group. The row Group is by region and the Column Group is based on the results from a column. Following an tutorial online, I got this custom code working for it. Dim values As System.Collections...
What is the meaning of varchar(-1) in SQL Server 2008? Is it an alternative for varchar(max)? ...
I have an instance of tfs 2008 supported by sql server 2005. I want to change the sql server machine by doing a restore based move. I also want to change the version of sql server to 2008. I know that i can restore backups from sql 2005 to sql 2008, IN GENERAL, but I don't know if this is a thing that is OK for tfs databases. I also k...
I've created a database application using C#, ADO.Net and an embedded MS SQL 2008 database file (that attaches to MS SQL 2008 Express) which I created in Server Management Studio. Can someone point me to a resource that describes how I can programmatically create the database file if it is missing (like right after my application is ins...
Looking for a "Source Control" plugin to integrate SSMS with Subversion/SVN. Anyone know of one? ...
When I attempt to expand the stored procedures tab in Management Studio I am getting the following error and no stored procedures are displayed. I've tried re-running all stored procedure scripts (which works without errors) and refreshing the tab, but I still get the following error: =================================== Could not conti...
My table (SQL Server 2008) has 1 million+ records, when I try to order records by datetime, it takes 1 second, but when I order by ID (int), it only takes about 0.1 second. Is there any way to improve the efficiency? (I already added the datetime column to the index) ...