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 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:
...
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...
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 ...
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...
Hi,
I need to create a table which has an auto indexing ID column. I've done this in Access and hope I can do it in SQL Express as well.
Any suggestions.
thanks,
newbieweb
I am trying to restore a database on a different machine and it's not working. I'm getting the error: The backed-up database has on-disk structure version 611. The server supports version 5...
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 ran through the sp2 install on my W2K3 SQL 2K5 Server and all completed successfully except the Client Tools. What are the ramifications of thes porblem? Here is the error portion of the log...
I have a requirement in SSIS to connect to a remote ftp site, download all files to a local drive and then remove only the remote files that I've transferred. The file names will be different ...
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...
How do I "read" a text field and add formatted text to it in SQL 2005? If not formatted, how to I add to it at all?
Best Case:
cola = 'some text'
after concatenation
cola = 'some text
...
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...
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")
We have a database that has:
FirstName
LastName
ImageName: the name of the image file in the filesystem ex: "Fred Flintstone" < no extensions
Dept: Department number
Image: This is empty ...
Hi there,
In reporting services, I've got a multi-value variable called @location_id. When the report renders it gives me a drop down list with a list of checkboxes so I can set the locatio...
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...
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 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...
Hi All,
I am having some trouble getting a Grand Total column at the end of my matrix report, such as you get by default in an Excel pivot table.
I have managed so far to add another col...
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 database that has several datetime columns. The thing is all I care about is the time portion of the column. The thing is I need to retain the numeric time value as I will need to d...
I am trying to import information from a spreadsheet for the first time in SQL 2005. I have done this many times in SQL 2000 with no issues. But now I am getting the following errors and I a...
