I am writing a script where I need to update two tables that reside on two different databases on two different servers. I am putting them in the same script and was wondering how I would go a...
Hi, whether I use the maintenance plan wizard or create a simple maintenance plan to backup databases, the plan fails. If I try to execute the associated Server Agent Job, it too fails:
St...
I am having trouble getting my new webpage online, I am running into the following error...
Cannot open user default database. Login failed.
Login failed for user 'NT AUTHORITY\NETWORK SER...
Hi
I've got a Excel spreadsheet and want to connect it to SQL server database and put data into it using a INSERT INTO statement
There's examples on internet of theory but I'd like to see on...
I am implementing a report viewer inside a web based c# application. The report viewer points back to reports being served out by sql reporting services. The ultimate goal is to have a netwo...
I'm using Reporting Services 2005 Standard on a Win 2K3 server. I have report that shows address information on the main sheet from a query and has an ID field in the main dataset that is a u...
I have a SSIS package that runs scripts (which create and populate a database) each night. The idea is to have a current copy of a DB from my client each night. Files are FTP'd to my server.
...
Hi,
Following an issue with one of our databases earlier today, someone attempted a restore from a file created from a maintenance job. They then stopped the restore as thet thought it wasn...
I'm developing a .Net 2.0 application and have run in to a bit of a problem. My application runs great for an hour or two, but eventually, I start getting Timeout errors when trying to execut...
How can I write a code to drop a temp table ( #temp) if it already exist?
Running into "insufficient memory to run query" errors when performing scheduled maintenance tasks. I suspect this is due to improper configuration of memory or page file.
SERVER: 2003 64bit...
I'm running SQL 2005 Management Studio on an XP Pro workstation and am running the following SQL Statement to prevent the insert of duplicate data from a Table called Software to a table calle...
I'm trying to restore a back up database into sql server 2005. And I'm having an error message says;
"Too many backup devices specified for backup or restore; only 64 are allowed. restore dat...
i've created a Integration Services solution in VS 2005. I'm in design mode. I've dropped a "foreach" loop container onto the designer "work area" and configured it to find csv files in a lo...
I have been trying to connect SQL Server 2005 via Linked Server connection to Active Directory and keep getting this error:
Msg 7321, Level 16, State 2, Line 1
An error occurred while prep...
We had a SQL Server 2005 x64 Enterprise SP2 attached to an MSA 1500 SAN with the HA kit. The backplane experienced problems and messed up the MBR on the two volumes where the data and log file...
I had Microsoft SQL Server Express 2005 installed already. I just installed the Microsoft SQL Server Management Studio Express 2005 and tried to open my mdf file. I get an error message that s...
I'm trying to update a field in table 1 (pricing.mod_type)to = a field in table 2 (archive.pendingmod), but I only want to select the most recent of [archive.pendingmod] based off of a increm...
We have a SQL 2K5 install and have the Server Propertioes ->Database Settings set such that the Database Default locations are S:\Microsoft SQL Server\MSSQL.1\MSSQL\Data for the data and T:\ f...
We have a MSSQL 2000 Server and a MSSQL 2005 Reporting Server. The reporting server has been running great with the 2000 backend up until recently.
Recently, because of the departure of a ...
I installed sql server 2005 on a machine called sql2. I had a live machine called sql1. After getting everything all setup on sql2, i removed sql1 from the domain, and renamed sql2 to be sql...
The trigger listed below is inserting two rows into the audit table requests_audit. I was under the impression this syntax would insert the specified values for _either_ and insert or and upd...
Hello Experts!
Suppose I have a table in my sql server 2005 database that contains an xml field (using the xml data type).
Now suppose that I use the following code to read data from that fi...
Am trying to convert an oracle table over to sql 2005. In Oracle this table had a before trigger on it so that when a record was insterted it would insert the next highest value into the prim...
Hi Experts,
Can someone please give me step by step clear instructions on how to recover a sql 2005 database using MDF and LDF files ?
Cheers
