Hi
I have a database who's status is currently (In Recovery / Read-Only). If I attempt to detach using Managment Studio it hangs. If I try to restart the database service it will not restar...
I would like to do real-time entry cell validation in a DataGridView. That is validate each cell immedately after it is entered. I have tried using the cell-validating event and the cell_en...
I need to build an aspx page to allow uploading an excel file and import the data into SQL server 2005.
I hear SSIS package is the best way to do the job. Since I am new to SSIS I have some q...
Hi,
I have one specific client database that is growing very rapidly and the LDF file is taking up more than half a TB. I have maintenance plans running differential backups from Monday to ...
I need help on how to append data in an excel spreadsheet to a sql server 2005 datatable.
Thanks
Hi,
How can i see a user list which connected to sql server 2005?
Here's the code I run in Oracle SQL * Plus but I can't get the DECODE part to work in Microsoft SQL Server 2005, any ideas ?
drop table sales;
create table sales
(customer varchar2(10),...
Would it be bad practice to have a trigger that fires on insert or update that updates a field based on the value of another field. For example, table contains boolean CheckedOut , datetime f...
I have a matrix that I am trying to add conditional formatting too.
I have already got the matrix to turn certain cells red if the month is now or later.
I now need to get values to go bold ...
When data is entered into a table the date is automatically entered using (convert(char(8),getdate(),112)) as the default value for the date field, which displays in the format - dd/mm/yyyy.
...
I have a stored procedure P1 which creates a temp table #tmpT1, this stored procedure P1 calls another stored proc P2, the insert in the temp table occurs in P2, when I do a select count on th...
I've installed report server but can't open the page in a browser. I get the following error:
Cannot connect to the configuration database. For tips on troubleshooting this error, search fo...
I could change the default database file location to other drive (not c: drive) for user databases. But how to change the default database file location to other drive for system databases dur...
I'm new to SQL EXPRESS. I had it set up a month or 2 ago working fine, but now it won't work. I'm guessing it's a permissions thing b/c I get a lot of those errors in general. I also recently ...
I have backed up an MSSQL 2005 'live' database called 'db_live' (which used physical files db_live.mdf and db_live.ldf)and restored it on my local server (again MSSQL 2005) to a database call...
I am getting this error message when I try to connect to SQL Server 2005 Express on another machine:
[error]
>sqlcmd -S MEDIA\SM700_DEMO
HResult 0xFFFFFFFF, Level 16, State 1
SQL Network I...
My website was compromised today and now every time I load a page from the database, the website download a Trojan horse to the user's computers. At first I was not sure if it was the code on...
Hi there, I have a series of statements that I'm placing the value of a select statement into a variable and then running an update statement. I'm having some problems with the Warning of nul...
Hi Experts,
I would like to join two tables based on fields of varchar() types
The difference here is that this 'ON' condition will not be a conventional one like this
SELECT * from
...
which the data type equivalent to double (access) in sql 2005, the decimal or numeric?
I have a SQL Server 2005 instance running on a server called MSSMLBIZ. On this host machine I have enabled named pipes, enabled TCP/IP, set the port to be 5356, run the Surface Area Configura...
1) Using Fill method of DataAdapter, opens SqlConnection and closes it after the query is executed. While using SqlCommand, we need to explicitly open and close SqlConnection. I want the SqlCo...
Hi,
I have a situation like this.I have a user login data table called LogTable where i have a set of Login, Logout date time details against a particular userid.The structure of LogTabl...
Estimating population standard deviation from sample standard deviation
In the real world, finding the standard deviation of an entire population is unrealistic except in certain cases, such ...
Hi experts i want to make ER Diagram of a database how can i make it , i can see diagram if
i expand database in management studio.what does diagram do can you explain me .
Thanks
