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 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 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 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...
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...
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...
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...
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...
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.
Hello Experts,
I have a very large Database (20,000+ records) which has time Columns (among others).
Time_1 and Time_2 have been entered with VarChar formatting. A time of 2:15 PM would b...
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 ...
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...
Most databases allow an existing column name to be renamed with syntax similar to this:
Alter Table
Rename colnow to colnew;
Cannot seem to find syntax for MSSQL to do this. Can/How can...
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/...
Dear experts, I am trying to use Case logic to a where statement in my stored proc. I have a Messages table that has messages a user has sent to himself or other people. I need some kind of If...
