I have a table with about 2500 records on it. I need to delete a single column of information from the table. How can delete the value in this single column for each record without deleting th...
Good Day
Experts:
I am getting this error "SQL Server blocked access to procedure 'sys.sp_OACreate of component 'Ole Automation Procedures". Using a db that I created here, I have no pr...
Is there a TSQL command to remove the identity attribute from a column? I can add one easily enough, and know that I could do this through the UI, but really need a TSQL query for this. I'm ...
Setup:
SQL Server 2005, VB.Net 2005 Windows Application
Problem:
at present i have a VB.Net program that creates CSV files, its opening the datareader and writing to the CSV File. the pro...
To me this makes perfect sense, but it never matches anything. However, I know there are some identical IP's in each of the two columns.
select distinct col_DestinationIp, col_SourceIp from...
I tried to give myself datareader and datawriter for my domain login and got this error below. I'm logged into the server with my domain account which has admin rights.
TITLE: Microso...
Hi,
My web form contains a textbox where users need to input date (dd/mm/yy), I am using a parameterized stored procedure to update my SQL DB table, but I am facing a problem with the date...
I'm working on an ASP.NET application that will update times from a table. I have a stored procedure to select the data that formats the date as a time value only, for example 16:00. In the ...
This question has been asked in a couple of different ways, but I think I'll need to ask in my own way.
I'm trying to connect to a SQL server and can't figure out why I'm having problems. ...
I'm getting the following error when I try to import a database from our live server to our test server:
Could not find server 'tmviis1' in sysservers. Execute sp_addlinkedserver to ad...
Hi,
I need to query a temporary table in a function which is being populated in some stored procedure. The call hierarchy can be understood as follows.
create procedure sp_PopulateT...
Hi Experts,
I am junior Sql DBA. I have migrated a few Databases from sql 2000 Sp4 on windows 2000 server to sql 2008 on windows 2003 server. I had no issues during migration, when i ran th...
I'm trying to get the count of unique records returned to a subquery. The query returns 1 row for each deptement. I need to reach across to another db where all users' logins are recorded. B
...
The log file of one of the databases on my SQL SERVER 2000 has grown to over 123GB. I need to shrink it down and control it's growth. It's on a 250GB drive with only 15GB free.
In SQL Ser...
I'm doing a data conversion. I need a select statement to create a number of rows of data. One of the columns in the row needs to be an incremental number starting at 6000.
For example if m...
The problem described occurs under SQL Server 2005. This problem did not exist using SQL Server 2000.
My production environment has two computers, each of which is running an instance of SQ...
how do i do "OR" inside the case statement?
please look at the below sql query:
SELECT
id,stat,
(CASE (flag_cd)
WHEN '1' THEN 'asdf'
WHEN '2' THEN '23423' END) AS mystatus,
(C...
Hi All,
I have a database which has every table prefixed with 'tbl_' and I would like to remove this. The problem is that there are stored procedures and triggers linked to these tables. ...
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...
I need to alter an existing column and I cannot seem to get the syntax editor to like what I enter or if it likes it, I get invalid data type.
ALTER MyTable ALTER myColumn int IDENTITY(1,1)...
I have a problem with sorting a alpha numeric field.
location_tag (type nvarchar(50))
1
2
3
4
10
11
20
Pad A
Pad B
If I do :
"SELECT location_tag from location ORDER BY locatio...
I have a SQL Server that has been working fine for the past year. But all of a sudden when I rebooted my server I got this error:
"The SQL Server (TESSI2005) service terminated with servic...
I would like to know how can i reduce the size of .LDF file?????
I have a file that gets exported from an Excel spreadsheet. The time in the spreadsheet is saved in 24 hour format as a number in Excel (ex: 0900 or 1530). When import SQL simply sees these ...
Good afternoon expert,
Have installed MS SQL Server 2005 (I think) but
I can find no Enterprise Manager when I go to
Start, Programs, Microsft SQL Server, the only
option available is ...
