I have a web app developed in Visual Studio (vb.net) that ties to a SQL Server database. One of the fields in the database is a datetime field. The form has two text boxes, txtDate, and txtT...
I am currently doing a Backup Plan for my Databases.(FULL Mode)
I have a database of 28MB but its log file is around 8000MB! How will i manage to clear the Logs?
I tried the following:
...
I am trying to use the APP.CONFIG file to store my VB.NET 2005 and an SQL Server 2005 DB connection string.
After spending the past hour reading over 40 posts here, I'm now mixmashing 6 pos...
I have a column (notes) that is a string. This field is periodically updated and more information is appended to it. (Not my design). What I need to do is be able to look for the last date t...
I have a nightly maintenance plan that backs up all SQL databases
I have one database that has the transaction log set to autogrow
The recovery model is full
Unless I manually set recovery ...
I fetch data from SQL Sever 2005 through MS Access interface using SQL Pass-Through Queries (SPTQ). I have two queries with the same sql text inside (please see the code snippet) and connect t...
I have a SQL 2000 DB with collation SQL_Latin1_General_CP1_CI_AS, I am attempting to upgrade and host this in SQL 2005 Enterprise x64 bit.
When I run the installer for SQL Server 2005 I get...
I have a SQL Server 2005 database, and it's data and log files reside on drive E:\
Hey is there an easy way to move the database (mdf, ldf) files from one drive to another?
What would be...
Hi,
Can someone help me as to why the following SQL is cause the error:
"The multi-part identifier "..." could not be bound."
Thanks.
---------------------------------
--regi...
Hi there,
One of our engineers has installed SQL 2005 Express on a customers PC that uses XP SP2.
I am trying to set up a remote connection from our offices but a this time I cannot even...
I have the following stored procedure:
---
create procedure uspGetRefills
@p varchar(255)
as
select * from uvwRefill
where Cast(MSRecID as varchar(255)) in (@p)
---
I want to pass in a...
How do I install 'Microsoft SQL Server Management Studio' on a Windows XP workstation? I want to have a user be able to manage SQL databases from their workstation so they dont need to use the...
i have a server that runs sql 2005 and the logfile has grown ridiculously high, which means the logfile is now 80gb.
i have a dev server with sql 2005 on which the logfile is 10gb.
i wa...
Can you tell me what the below expression mean?
=iif(RunningValue(FormatDateTime(Fields!COLLECTED_DTTM.Value,2) & Fields!ORDER_NUMBER.Value,CountDistinct,Nothing) Mod 2, "White", "Yellow")
I need to rename a column name in a sql stored procedure during a process.
Hi,
We have an instance of SQL Server 2005 running which we've already installed with Deafult settings on a Windows 2003 server.
We're implementing a 3rd party software that will use this ...
I have a log file that has grown to 18gb and I am afraid to leave for the weekend without doing something about it. We only have 10 gb of space left on the SQL Server c:\. I have my it guys ...
while designing a table in SQL Server 2005, what data type should I give for a field with boolean values ? There does not seem to be a Boolean data type in SQL Server 2005 !
Hello
The service SQL Server ACtive Directory Helper (Auto Start Service) has stopped running, when I go into Services in the MMC and try to manually start it I get the following error:
"Win...
i have table named table tbl_Data.In it there is a column name servicename .This column has number of records like SCXE1023PLUS,SCSCXE10234PLUS,SSE1024,SSE10245.So i need a stored procedure th...
I am recently unable to connect to connect to the MICROSOFT##SSEE SQL instance using SQL Management Studio. It houses my WSUS 3.0 databases. Upon starting the server I see this error in the ev...
Hello Dear Expert,
I got this error in SQL Server 2005, when I tried to import data from Excel using import/export wizard.
"Error 0xc00470fe: Data Flow Task: The product level is insuffi...
For several weeks this one computer won't accept the Security Update for SQL Server 2005 Service Pack 2. At the end of the attempt the Grey dialog box displays:
Some updates could not be i...
This question is as simple as it seems.
I have SQL Express 2005 on my Win2k3 SBS box. I want to create a new instance that another program can attach to. How do I do that? For MSDE, I co...
I know this is an easy one and I have seen the solution before but I'm tired and can't figure it out.
I am getting an error
Conversion failed when converting the varchar value '../image/...
