I have two queries, calculating an array of values, the sql below gives me a list of values, however i would like to get the sum of these values only.
How would i do this ?
encapsulating eve...
Hi,
I am having a time installing a software demo that uses SQL EXPRESS 2005. It runs fine on a single machine (XP Pro), but when I install the software on another workgroup machine and attem...
any idea how do I perform the sql hotfix installation in cluster env? is the procedure same as installing the SP in cluster whereby the patch need to be install in active node only?
A co-worker left my company and now I am responsible for the replication we have setup b/t two databases on the same server. I have a number of questions that were not answered by my reading ...
I'm writing a simple SSIS package script [my first SSIS romp] and I'm running into a headache that won't go away. When I have CopyAllViews = true or procedures as well i get back a standard SQ...
Notes:
Server name: SERVER
Server software Windows Server SBS Premium 2003
SQL Server: Microsoft SQL Server 2005
Workstations attached to domain server
I have just installed SQL Serve...
We have an old Compaq running NT 4, sp4, hosting our SQL 7 SP4 database.
We have purchased installed updated and prepared a Dell Server running SQL2005 sp2.
We are looking for guidance ...
Hi experts,
i have a web application residing on a web server. From that application I would like to access data stored on a DB server. When I try to connect, I get the following error:
...
My report does not display all the data that is in the returned record set. I have checked the underlying query outside of RS and I get 33 rows. The count variable on the report shows 33 rows ...
This is probably very simple, but need someone to point me in the correct direction:
I want to add an incremental field based on a unique key and when the unique key changes then it resets ...
Hi,
I posted on here a couple of weeks back in relation to working with sql server xml datatype and importing xml documents, I now have a process of importing the documents but seem to be ...
I am trying to import data using SSIS from Paradox Database/File into a SQL Server 2005 Database.
I am trying to use SSIS to import the data.
I create tow connection, into [Connection Ma...
Hello all,
While in my production sql server, I open the performance console. In the system monitor or Counter I attempt to add a counter for the performance object SQL Server: Databases. ...
Are there are special securities i need to give the server to make xp_cmdshell run in a maintenance plan? I'm executing a stored procedure through a maintenance plan. My stored procedure call...
Hi
I have two tables
1 - a users table containing userid, username
2 - an access table which contains the userid and a pageid (if a userid and a pageid appear on the same row in the table t...
After some google searches, I've incorporated the recommended method to search a local network for all available SQL Servers. I've attached the code snippet to demonstrate all I'm looking for...
I need to create a single string variable containing the values of a varchar column from a result set that may contain a number of rows. I am not concerned about overflow, as the number of ro...
Hello:
I have a brand new SQL Server 2005 with a few 5GB databases. In my main database I want to set up transaction log backups every 15 minutes. Also, differental backups every 4 hours....
I have a stored procedure that checks a column in a table every 15 min for a finished flag. Once found I want to execute a stored procedure and then disable the job. If the finished flag is no...
Ok so im on the road to getting to grips with sql server 2005 and teaching myself tsql with a couple of books and using access sql view to lend a hand
I have a function set up to convert my...
Dear Experts, I have a problem with some system objects in SQL2005:
Previous explanation: I have an old aplication that was developed using SQL 6.5 database, since SQL6.5 I have upgraded to S...
I have had log shipping set up for some time now and it is running great (i think). Yesterday I noticed that a table I added to a DB a few weeks ago (after log shipping was established) on the...
Is there anyway to out put the table structures of SQL Server tables in a database? I am trying to create a data dictonary of an existing database, but the task is pretty boring. I want to jus...
Does any have a scripts that I can use to poll the backup history for 10 or more SQL Server 2000 & 2005 database servers? I am trying to create a global report on the backup history for all SQ...
HI there, I have two SQL 2005 instance, one on a laptop, let's call it GBE and another on VM. Each of these laptop have a second network interface created with OPenVPN to isolate them in a nic...
