Fellow Experts
SQL isn't my strong suit. We have an SQL 2005 Standard that holds all the company's databases. One particular database's LDF file has grown to 16 Gb. The MDF file is still at...
Hi,
We're looking to see if it's possible to build the 'ultimate' SQL server.
To have it load balanced, and high availability. We are looking at using NLB and peer to peer transaction r...
I have sql server 2005. Please tell me a command to reindex all tables in my database.
I have a database that for some reason the initial Log size appears to be changing on its own. I want it set to 1024 MB and I have set it to that and closed the Database properties window. I t...
Hi Expert!
I need insert UMLAUTs (like ä,ü,ß) into MS SQL Database.
The INSERTs are stored in .sql files. These files we are using for Oracle and for MS SQL.
Fragment of the .sql File...
Hello,
I am trying to install the Microsoft SQL Server 2005 Service Pack 2 on a Microsoft Windows Server 2003 machine. It gives an error installing the following:
1. Notification Services
...
Our hotel booking table uses only StartDate and EndDate fields. Days between the two dates are booked.
My challenge is to find gaps of X consecutive days in a two-month period. In that tim...
Hi there,
I need to detect the presence of linefeed/new line characters in a string I'm parsing in SQL 2005.
The string is of the format ~1000~3483923~893493~...~A~Temp~End
The elements a...
Hi All,
I have a 72GB database. I want to shrink this database as much as possible.
Under SQL Managment studio when I see the property of this dataabase, the size of the database is 7307...
Greetings all
I am looking firo a tutorial that will stepo me through creating a Matrix reprot with SSRS 2005.
Any thoughts?
In advance, thanks!
allanmark
I have multiple (many) strings in item.image that follow the same format:
I.E.
119267-LEOPARD.jpg
113277-TIGER.jpg
And, I want to replace everything from the left hyphen to the perio...
Hi,
I am relatively new to SQL Server 2005.
I run this query:
SELECT name FROM sysdatabases WHERE DATABASEPROPERTYEX('AdventureWorks', 'RECOVERY') = 'SIMPLE'
Why it returns all 5 data...
I have been working on passing a Value into a SSIS Package Parameter for 2 days....and I really need serious help!!
I have a package named "MDist ALLData Import.dtsx". Here is my syntax:
EXE...
I have noticed in the Event Viewer of our server a brute-force attack on our SQL server - with some 70,000 attempts to login to the SQL 'sa' account in the last two days.
We already have a...
Hello,
I am being tasked with tuning a SQL server's RAID array for optimal performance. I have done some of this type of work in the past but never to the degree of what is now being asked ...
I am used to using SQL 2000, but now I am using the SQL 2005 Management Studio, although I am generally still accessing SQL 2000 servers.
In SQL 2000 Enterprise Manager, when accessing a lo...
I am fairly new to sql server 2005 cluster and have a question regarding installing patches/hot-fixes. We have a active/active/passive cluster. This is what I believe needs to take place, ple...
I want to insert a date into a table.
I have the following code and the 1st line does not compile.
Is that because I have an Access frontend and a SQL backend.
Table - tblDaily
field to in...
SQL Server 2005 ROWID - invalid column name I keep getting an invalid column name message from the attached code... The trigger works if I comment out the where clause... I even tried usin...
looking for a working sample for how to export/import SQL server 2005 table data from remote client machine
Description
DBA migrated DTS package to SSIS. SSIS package runs as scheduled.
However, SSIS package cannot be exported through SSMS or BIDS.
This prevents any edits that developer or DBA ne...
Hi Folks,
I just noticed that reporting services is not started on the Operations Manager Server and probably has been stopped for quite a while since we patched the server to 9.00.3073. It w...
I have a Windows XP desktop running Micrisifts Small Business Accounting Server 2008 and it wquit running yesterday. The SQl server will not start and I get the following error in the event v...
I have a SQL Server 2005 instance running under the Local System Service account. I'm using Windows Integrated Authority in my web service web.config <connection> string to authenticate vs. S...
When I do the restore from device in SQL 2005, the select path box option is grayed out. The database I am trying to restore is on backed up on another server.
