I have absolutely no idea how to do this and my current experiments just end up with the same old errors. It should be simple but i cannot get it to work. I'm not even sure which datatype to use in the db. Any help would be much appreciated ...
I have a WinForms C# application using a MS SQL Server Express database. The application is deployed on the PCs of our customers and they don't have computer related knowledge. The application updates the database regularly and I see a lot of fragmentation on the index files. How do I keep the database healthy/responsive over time? ...
I have two databases, one is an MS Access file, the other is a SQL Server database. I need to create a SELECT command that filters data from the SQL Server database based on the data in the Access database. What is the best way to accomplish this with ADO.NET? Can I pull the required data from each database into two new tables. Put thes...
In SQL Server, why is this: [dbo].[table_name] preferable to this: dbo.table_name And along those lines, why even list the dbo at all if there's only one schema? ...
I need to be able to schedule a job on the 10th of each month and have it run for a set number of days or until a specified date. Is there any way to customize sql server agent jobs using some sort of API or something? Thanks. ...
I'm running SQL Server 2000 and I need to export the SQL Statement from all the DTS objects so that they can be parsed and put into a wiki documentation if needed. Is there a way to do that? maybe dumping each DTS object out into a text file with the object name as the file name with the name of the process and the date it was extrac...
Is it possible to not have the: /**Script Date: 10/27/2008 09:05:41 ****/ in the output? I want to use Diff's so I can see what's changed, having a timestamp makes it difficult! ...
I currently have an asp.net website hosted on two web servers that sit behind a Cisco load balancer. The two web servers reference a single MSSQL database server. Since this database server is a single point of failure, I'm adding an additional MSSQL server for backup. I would like to setup my web.config files to write everything to b...
I been trying to get sqlcachedependecy working, but it doesn't appear to work I got the proper settings in my web.config and also global.asa, however when I run this query and the changes are made to the database from either with in or outside the web site the cached objects are not updated please someone help? I know its not because t...
For this xml (in a SQL 2005 XML column): <doc> <a>1</a> <b ba="1" bb="2" bc="3" /> <c bd="3"/> <doc> I'd like to be able to retrieve the names of the attributes (ba, bb, bc, bd) rather than the values inside SQL Server 2005. Well, XPath certainly allows this with name() but SQL doesn't support that. This is my chief complaint wi...
Hi Reporting Services 2000 Standard Edition (currently RTM but hope to have SP2 soon). I have a report which takes in a parameter - PlantID I'd like to email a pdf of this report every month to the 80 different plant managers So I have a table: PlantID ManagerEmail 1 [email protected] 2 [email protected] 3...
My client has an old MS SQL 2000 database that uses varchar(50) fields to store names. He tried to use this database to capture some data (via a web form). Some of the form-fillers are from other countries, and the varchar fields went nutty when some of these folks entered their names. Is it possible to recover the data somehow? Maybe by...
I have a number of generated .sql files that I want to run in succession. I'd like to run them from a SQL statement in a query (i.e. Query Analyzer/Server Management Studio). Is it possible to do something like this and if so what is the syntax for doing this? I'm hoping for something like: exec 'c:\temp\file01.sql' exec 'c:\temp\fil...
What is the use of Cursor Auto Fetch in SQL Server? thanks ...
I am trying to execute this SQL query prior to restoring a .BAK file in SQL Express. Initially, I had the file on the Desktop of my user account. I am logged in as Administrator. When I try to access the .BAK file on the desktop like this RESTORE FILELISTONLY FROM DISK= 'C:\Documents and Settings\Administrator\Desktop\file.bak' I get...
My account is in the securityadmin role and I cannot grant myself sysadmin permission. I wish to gain access to a database so I can add my account to a particular role within it. As I don't yet have access to the database I can't use the UI. Does anyone know if this is possible and what SQL commands will achieve this in SQL Server 2005?...
We have an application that use MSSQL, when we move to 2005, basically we recommend to our client to apply the backward compatibility package and that’s it, but somebody ask me what to do to be 100% compatible on 2005. I was thinking on 1. Compatibility level: SQL Server 2005 (90) 2. Remove any DMO reference, and replaced by SMO 3. Conne...
So I have this large XML file containing 300+ elements for each record and I need to insert these records into a database table. The name of the nodes in the XML file are the same as the column names in the db. And they're all strings. Is there an automatic way to map them and insert the data or will I have to write out lines of code map...
I have a set of tables that are used to track bills. These tables are loaded from an SSIS process that runs weekly. I am in the process of creating a second set of tables to track adjustments to the bills that are made via the web. Some of our clients hand key their bills and all of those entries need to be backed up on a more regular s...
Hi, I remember hearing Joel say he has 2 different locations where the servers are located, each location has 2 front end servers and 1 back end server. If a one of the hosting facilities goes down, how can he switch over to the other one? (Or is it just going to be a DNS change that will take 24-72 hours to propagate?). How can a si...