Hey All, I have been working on this problem for a while and the usual google searches are not helping :( I have a production database in SQL 2000. I want to copy it over the top of a training database to refresh it. I want this to be something that is scheduled to happen once a week to keep the training database up-to-date. I have a D...
If a table has a rowversion column in it and you make an update to that row, the value of the rowversion column increases. I know that this is by design and the purpose of rowversion columns, however is there any way to make it such that an update operation will have no effect on rowversion value? Edit: Tracking of updates on all co...
I need to know the maximum length of a textbox in ssrs. How much data can it accomodate? ...
I know a role name and want to find all users in this role. How do I acheive this in SQL Server 2000 (in the SQL script, not in Management Studio or other tool)? ...
So I need to update a text field. Neither the UPDATE statement or the WRITETEXT statement work when used below CREATE TABLE MyTable (IDField int, MyField text) INSERT INTO MyTable (IDField) SELECT 1 DECLARE @Data1 varchar(8000), @Data2 varchar(8000), @ptrval binary(16) SELECT @Data1 = REPLICATE('1',8000) SELECT @Data2 = REPLICATE('2'...
Is it possible to restore a backup of a SQL Server 2005 database onto an instance of SQL Server 2008? I need to rebuild a server as it's getting rather crufty, so I plan to take this opportunity to upgrade to SQL 2008 and wondered if I'll be able to restore my backups OK. ...
Although using SQL FOR XML EXPLICIT is cumbersome, I find myself using it often. Since it allows full control over the generated XML document. My problem is with perfomance, sometimes it would take more than 5 minutes to generate an XML document describing some financial data (invoices, bills .. etc.) for just one month! So I was looki...
Hello all. I am working with Crystal Reports and MS SQL Server. I need to remap the crystal report to point to a different database on the same SQL Server. Is there an automated way of doing this, or do I have to remap for every single report? I am currently doing this by adding a new data connection, and then updating the stored proced...
We have an application that installs SQL Server Express from the command line and specifies the service account as the LocalSystem account via the parameter SQLACCOUNT="NT AUTHORITY\SYSTEM". This doesn't work with different languages because the account name for LocalSystem is different. There's a table listing the differences here: ht...
In my SQL database, I have a one-to-many relationship, something like this: Teacher Student John Alex John Mike John Sean Bob Jack Gary George Gary Paul I'd like to display a table listing each teacher, with their students as a comma-delimited list, like this: Teacher Students John Alex, Mike, Sean Bo...
I am dynamically adding steps to a Sql Server Agent Job, but I need to get the last step id to determine the next id in the sequence. I cannot seem to find any built in sps that can give me this information. ...
I’m building a system that generates “work items” that are queued up for back-end processing. I recently completed a system that had the same requirements and came up with an architecture that I don’t feel is optimal and was hoping for some advice for this new system. Work items are queued up centrally and need to be processed in an es...
I am using Visual Studio Team System 2008, version 9.0.30729.1 SP. I have a database project that I was working with yesterday with no issues - I was able to build and deploy the database successfully. Today, however, when I open the solution I receive what is listed as a "Warning" that halts any Build/Deploy/etc process, but cannot be s...
I wish to migrate the database of a legacy web app from SQL Server to MySQL. What are the limitations of MySQL that I must look out for ? And what all items would be part of a comprehensive checklist before jumping into actually modifying the code ? ...
I'm working on an application for work that is going to query our employee database. The end users want the ability to search based on the standard name/department criteria, but they also want the flexibility to query for all people with the first name of "James" that works in the Health Department. The one thing I want to avoid is to si...
Hello all, I need to reproduce a bug, and a guy from the other team has sent me a .mdf and .ldf files from his sql server 2005 instance. When I attach the database, all I get is empty tables, even though file is 2 mb large. The db contains 2 tables that have, among other thing, a varbinary(max) field. At the same time another database, ...
I have a database with DateTime fields that are currently stored in local time. An upcoming project will require all these dates to be converted to universal time. Rather than writing a c# app to convert these times to universal time, I'd rather use available sqlserver/sql features to accurately convert these dates to universal time so...
Hi everyone, I need some help into this problem: Basically i want to connect my program which uses c/c++ to a SQL server database (MS SQL server express or standard edition) , because of our users demands the program needs to be ported to Mac Os too so this connection need to be portable. Any idea of a portable API i can use to do t...
Is there a way to connect to a db with Integrated Security from multiple domains? ...
I was asked this question at an interview and had no answer. Can anyone here explain? ...