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 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 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 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 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 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...
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...
How to split string in sql server 2005 using character? I want to use every part of splitted string.
There is split function available in VB or VB.NET, but how can i do this in Transact-sql.
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...
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...
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...
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 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...
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 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 the attached CASE statement for one condition but I would like to add a second statement based on this CASE block but I dont know if it can be done this way:
I would like to declare ...
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/...
Hi,
I have a DateTime variable:
DECLARE @Date datetime
SET @Date = '2007-07-20'
After I'm done with this, How can I modify the @Date variable to something like this:
DECLARE @Modi...
given a cell in column TOPIC, how do I write a select where the X position of a character in a cell results in a 1? The cell is in nvarchar and always contains a string of 1's and zeroes
F...
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 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...
Hi,
I was changing some settings in my sql server 2005 Configuration manager. Settings like Enabling TCP/IP, so change of settings asked me to restart the sql server. BUT when i have stoppe...
if i have a dynamic sql query something like this
set @strsql = 'select @somevar = somecolumn from ' + @tablename + 'where condition '
exec @strsql
it does not populate the @somevar vari...
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")
Hi,
I'm stumped and I need your help.
In essence what I need to do is query a temporary table (TempUpdate) that receives nightly updates from an outside source and update the Locations table...
