I want a select statement which selects records where field fldName contains any lowercase letters.
Is this possible?
i need to load an excel worksheet using the OPENROWSET functionality. i don't always no the name of the worksheet. i have clients uploading an excel file unto my ftp server and the worksheet n...
Hello. I can't access a linked server from a workstation using Enterprise Manager.
I have a SQL2008 server and a SQL2000 server. I have set the SQL2000 to be a linked server on the SQL2...
Hello experts.
Trying to start the SQL server service i get the error:
SQL Server could not find the default instance (MSSQLSERVER) - please specify the name of an existing instance on the i...
In Oracle to drop a foreign key, i could do this to the parent table:
DROP TABLE table_name CASCADE CONSTRAINTS;
In SQL Server i have to drop the foreign key manually as:
ALTER TABLE ...
Hi,
I have a job "MessageBox_Message_ManageRefCountLog_BizTalkMsgBoxDb" Which runs for every 2 minutes, is failing ever day, i have pasted the job history below. Please look into that and p...
I'm trying to pass the @@Identity value from a stored procedure into SSIS and getting an error message: Value does not fall within the expected range.
I turned on a trace and captured the...
Hi,
In a view, I want to do this: where (t.theDate between (convert(char(10), getdate(), 103) - 16 and (convert(char(10), getdate(), 103) - 2) but I get an error message stating that a date v...
I'm an Access developer, now learning Visual (Basic) 2008 Express, and am trying to connect to a sample database created in SQL Server 2008 Express, but cannot navigate to the required db file...
I am attempting to read a text input file, check to see if the record already exists and if not, insert it. If it exists, I update it. Since I want all records to work, or none of them to work...
SQL 2005, only have access via MGMT Studio Express so an INSERT query of some sort would be ideal.
Column - 'Sequence'
I have 2000 rows, each row within the column needs a number, beginn...
I have a SQL job that can take a variable length of time to run. I have another job that runs on a closer schedule. If the second job starts while the first is running, it will fail. I'd l...
Hi folks. I created a stored procedure for paginating search results using ROW_NUMBER() for a web application I have inherited. The app searches for Programs whose records contain a given Keyw...
how can I install Microsoft Distributed Transaction Coordinator (MSDTC) on Windows Server 2003?
Just a simple install (no clustering or anything)
Hello,
We are trying to insert a record into MS SQL table. We know our character value is too long. We don't want to shorten it. Is there any way to have the server just truncate the value ...
Hello Experts
When I perform a db search from one of the asp.net page of the website, w3win.exe*32 and sqlserver.exe eating up all the memory and about 80% cpu usage, crashing the website r...
Hi to all,
I inherited a SQL database where I found that there are a lot of duplicate records of the same item. I need to be able to consolidate all the duplicate items into one item. There...
I have a table setup with a unique ID, and 5 elments. This can repeat many times for each unique ID. The follow query pulls the data:
select uniq, VT2008REV.REVCODE, VT2008REV.DDATE, VT20...
"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does...
Our MSSQL Server 2005 crashed this morning. The CPU was used at 100% and Server Management Studio was not responding at all. It was Impossible to connect to the server, nor restart the MSSQL S...
Question: How can I query EACH of my Client's databases, looking in each DBs user Table Login_Log_Table for a field named Login_Date. I'm just trying to get a list of Clients who have logg...
Please help, I am not familiar with triggers. I would like to create an update trigger to modify the column DateModifed for only the row updated.
Here is an example of the table:
ObjI...
I have a View that combines data from two tables via the following SQL script below.
We had a recent requirement change that resulted in dept becoming an integer field, while DeptName remaine...
I am running SQL Server 2005 on windows 2000 server machine with 16gb of ram. What would be my most efficient memory settings because I am getting serious sqlservr.exe memory spikes. Dont know...
All,
I have a quick question. How can I check to see if the first position of a varchar field is numeric?
Any information would be greatly appreciated.
Thanks
