We just moved our web server off site and now I would like to keep a warm standby of both the website and database (SQL 2005) on site.
What are the best practices for going about doing this w...
I have a column Loadon in which the last two year data is exsit according to date wise.
Is it posible the data is return to me in query only month+year in order to month.
my data is in f...
I installed SQL 2005 Eval and SQL SP2 roughly 4 months ago to test a new application. My Client liked it and i purchased SQL 2005 Standard through Microsot Volume Licensing. i downloaded the s...
On SQL Server 2005, looking for the easiest way to add a "date modified" column for all table rows. If adding a trigger is the only way please provide trigger definition/t-sql.
thanks!
I have a SQL Server software application that received the following error when opening on 2 users machines:
"A database operation failed to complete successfully. An error has occured whi...
I moved a working SQL Server 2000 database to an SQL Server 2005 and now I found some particular case sensitive problem in query syntax.
I have a query like that SELECT Lang_ID FROM Lang
I...
Between 6/18 and 9/18 someone has deleted a table on the SQL 2005 server. I have the data to restore the table but I'm more concerned with who deleted it. Is there a way to find out?
Is there any way which I can grant sql login with add linked server permission?
Hi All,
I have written a function for finding Median value for a column in the table, and its running fine.
I have currently hardocded the table name and column name and would like to para...
I get a following error when I try to start SQL Management Studio 2005. How can I fix this?
An error has occurred while establishing a connection to the server. When connecting to SQL Serve...
Hi,
I am trying to find out how I can write some SQL that will allow me to filter in my WHERE clause the current month till date.
So if I want to see all employees or whatever who starte...
I am getting this error message when trying to execute this stored procedure. Can someone elighten me what this error means.
USE [The Doctors Center]
GO
/****** Object: StoredProcedure ...
I created a report using SQL Server's Reporting Services. The report is a matrix report. Is there a way to show the column header? The only value I see a header on is the detail of the repo...
I have 2 parameters: NodoKey y NodeElementKey. With the NodeKey parameter I execute the following query: select FuenteDatosKey nameTable01 where NodeKey = @NodeKey, this it can show of 1 n row...
We have sql 2005 std 32 bit installed on a 2003 standard server the default instance is up and running. I need to install a named instance and am gtting an error just before the end.
If i ...
I have a publisher -> subscriber set up with a SQL 2005 database. I have certain table permissions set on the production database (the publisher). And after the replication happens (every 15...
Whenever I run DBCC DBREINDEX on a very large table (>130GB of size) i receive the "PRIMARY filegroup is full" error. My basic understanding is DBREINDEX affects transaction log size but why t...
IN SQL 2005 we currently zip our nightly full backup due to space constraints, however the delete file task in 2005 doesn't work. Digging around this is because it tries to analyze the header ...
I have two type of data access, massive amounts of data loading and user access (small queries). I do not want the user access network I/O to be blocked by the loading network I/O.
My thoug...
I would like to import roughly 30 files from text files into SQL.
All files have a head row, so i would like to keep that to form the structure of the file. The field type and lengths can b...
Hi,
I have a setup with SBS 2003 R2 Premium as the mainserver running a database on SQL2005. One part of this software requires the use of analysis and reporting services which are not ava...
All,
I have an SSIS package which has a SQL task that saves its XML result set as a variable(string). Many of these result sets may go beyond the 4000 character limit of the string variable...
Hello and thank you in advance for your assistance.
I have a sqlserver 2005 database with a linked server to an MSAccess db.
I have written a series of queries that I need to be able to acce...
Hi,
i have a requirement where in I want to generate a pivot table for the range of values. Please find the .doc file attached for the details.
If the exec stored procedure does not return any rows then the meta data information is not visible in the output. And getting an error in the Data flow task.
In the dataflow task we are ...
