New to SQL Server 2005. I'm wanting to batch upload data from a remote system (VMS) into a SQL Server 2005 database. I've scripted out into files, the commands I need to create the table(s),...
Hello
I keep recieving the following message in Event Viewer:
"The time stamp counter of CPU on scheduler id 2 is not synchronized with other CPUs." Event ID 17896
It is an informatio...
Hi,
The log file will not shrink in size.
I used the following commend (to no avail):
CHECKPOINT
GO
DBCC shrinkfile('DBNAME', 1)
GO
BACKUP LOG CAM WITH TRUNCATE_ONLY
GO...
Looking for the most efficient SQL query to return rows that contain any non-numeric value in a specific field. The field is of datatype varchar, but I must identify any entries that contain ...
Is there and LDF and/or MDF viewer?
Hello, I am investigating virtualising our company infrastructure. The project is moving quite quickly and I need to decide on a strategy for our SQL 2000 cluster. I want to virtualise this bu...
Event Type: Error
Event Source: Report Server Windows Service (MSSQLSERVER)
Event Category: Startup/Shutdown
Event ID: 117
Date: 7/30/2008
Time: 9:10:34 AM
User: N/A
Computer: Basra...
Hello,
Iam totally new to SQL Administration and I am assigned with the task of running something like this.
osql -U sa -****@**** -S &&&&&\sqlexpress -d centers -i "c:\bfd\Centre scri...
I want to find all terminated employees on the tblemployees table that have been terminated in 06 that did not have any records on the sickdays table. I am having a hard time using the correct...
I'm sure it's something simple but I've only done a few stored procs, and none of the previous ones used rollback.
Error is as follows:
Transaction count after EXECUTE indicates that a C...
Hi Experts,
Does anyone know what determines the date time field format in a MS SQL database field?
Is it based on your local pc's regional settings or does MS SQL forced down its own form...
Hello Experts,
i got a huge dabatase where its mdf file is about 22G of size!! I need to reduce this size. I was thinking of shrinking the database, it seems that the admin who left set a s...
I am querying an excel file from my SQL server using OPENROWSET. I would like to query a specific sheet and a range of cells in the sheet. The problem I'm having is due to there being a space ...
I have a Data Set in SQL Reporting Server. I attached the code below. Data produces following results:
DisplayName, FirmName, Address, City, State, PostCode, ***(BUID)***, ***(Count J.JobNo...
We imported a flat file generated from a *nix system into a MS SQL 2000 table, which sits behind an Access application.
One column in this flat file is text, and this (for better or worse) ...
i'm trying to pull data out of a column that looks like such:
(Open,7/15/2008 9:23 Open,7/15/2008 10:26 Assigned,7/15/2008 10:27 Assigned,7/16/2008 14:11 Closed,7/16/2008 16:22)
All i ...
Hi there,
Is it possible to get the client process ID of an application that runs on SQL server?
when i connect sybase using server link in sql ser 2005 that time give this error OLE DB provider "Sybase.ASEOLEDBProvider" for linked server "MPHASIS_LINK" returned message "Login Failed, Che...
I have a SQL DB MDF file that's 300MB but the LDF file is 3gig, I checked the loggin and it's set to simple, I backup nightly what am I missing?
Hi - trying to create a query that is the OPPOSITE of the query that is written below...seems easy enough but it isn't returning data.
I want to select all the records from G that do NOT have...
I have a stored procedure on SQL 2000 that builds a temp table, and it also executes another stored procedure which returns a result set. I need to populate 3 of the fields in that temp table ...
When I attempt to open a view in a SQL 2005 database I get the error "conversion failed when converting from a character string to uniqueidentifier". If I try to connect to the view through e...
I have 2 tables.
tblParts
columns: PartID, PartNum, PartPrice
tblPricing
Columns: PricingID, PartID, PartPrice1
When a Part is updated or inserted i want to insert the new price...
The CPU goes to 100% and stays there.
The same database and the related applications were working fine with 32 bit SQL Server with same amount of load.
The funny part is none of the database...
Hi,
We have a SQL 2000 server and unfortunatly about 2000 records have been deleted from 4 tables within the system, now I have a backup from last night, however I CANNOT restore the entire...
