how to know how many users are connected to a particular database in sqlserver2000
how to know how many users are connected to a particular database ...
sql-server
How to display varBinary field data.
I have a database field whose dataType is varBinary. Now in a gridView I want to display that data. But i am getting output: System.Byte[] not the value 0x2C6D1A which is in the database. Please help how to solve this problem. ...
Dataset Acceptchanges in SQL Server
I am loading my ADO.net dataset in by select query in command object. If I clear the dataset data with Acceptchanges will it delete the data in the sql server. If not Please let me Know how to do? ...
Encode xml column values as xml in sql server
I have a method that is taking vales directly from the database, building a string of xml and then writing the xml to a file. This is fine until I get special characters eg "'", "<", "&" etc. Does anyone know of something in Sql Server that would allow me to encode the values as i select them; for example; select encode(service_status...
Using a Word document as a template for an SSRS report?
Greetings. I've got a few Word documents that I need to send as notifications when something happens. I've got to fill 10 parameters or so from our SQL Server database. Note that I don't need to send them as word documents, PDF will be fine - I was just given them in .docx form. Now, I immediately thought SSRS was the way to go here....
How to pronounce @@error
How do you refer to something like @@error (T-SQL) when speaking? Is it like "at at error" or do you just say what it actually holds/represents (the error number)? ...
How to retrieve the datetime when one row was inserted/updated in Sql Server 2005?
Hi, Is there a way to find out that info? Maybe in some kind of internal log in Sql Server? I need to generate a report based on historical data, but I haven't implemented that feature in my app, as it was not a requirement in the past. Now I'm stuck. Thanks ...
SQL Server Process Queue Race Condition
I have an order queue that is accessed by multiple order processors through a stored procedure. Each processor passes in a unique ID which is used to lock the next 20 orders for its own use. The stored procedure then returns these records to the order processor to be acted upon. There are cases where multiple processors are able to ret...
Reclaim space in SQL 2005 table after changing datatype?
I inhereited a database with tables with many nvarchar columns. The tables were getting fairly large, and I decided to change the datatypes to varchar to cut storage because we do not use international characters. The "data space" on the table (Right-click, then "Properties") has not changed. However, if I copy this table into a new tabl...
How do I use a transaction in LINQ to SQL using stored procedures?
I have a piece of code that looks something like this (ClearImportTable and InsertPage are stored procedures): datacontext.ClearImportTable() //Essentially a DELETE FROM table for (int i = 1; i < MAX_PAGES; ++i){ datacontext.InsertPage(i); //Inserts data into the table } This is a somewhat simplified version of my code, but the id...
To Find the registry of SQL Server 2005 Management Studio
hi all.. i want the registry value SQL Server 2005 Management Studio (because our application is dependent;) before installing our application i am checking whether SQL Server 2005 Management Studio is present or not and i have cross checked that for SQL Server Management Studio with Express Edition it is having different registry value...
Dynamically finding column values in a trigger from INSERT when the column name is a variable
I have a trigger that gets inserts and updates to a view. I need to find the columns that are being modified and get the value into the correct table. INSERT INTO TempTableAttr_Lot(ID, [% Num]) VALUES(3, 24.0) I am trying to figure out how, in my trigger, to get the value of ID and [% Num] columns. The problem is that there can be 32...
Audit whether stored proc was executed - in the transaction logs
We have SQL Server 2005 database with full backup and transaction logs. We have a problem with the database - and need the SQL CSI Forensic team to help. Is there a way to look at the transaction logs and identify whether a stored procedure was executed? We know the time that it happened (if it happened) but there is a dispute wheth...
SQL Server FTI: How to check table status?
In the SQL Server Full-Text Indexing scheme i want to know if a table is in start_chage_tracking mode update_index mode start_change_tracking and start_background_updateindex modes The problem is that i set my tables to "background update index", and then tell it to "start change tracking", but then some months later it doesn't seem ...
Multipurposing a failover server?
I'm not a DBA so this may be a stupid question but I'll ask it anyway. We're upgrading our SQL Servers from 2000 to 2005 and we will probably use either database replication or database mirroring. Our DBA would like to "multipurpose" the standby server meaning that he'd like to increase our capabilities and capacity by running other da...
ASP.NET MVC Debugging Very Slow - SQL Server Express Connection Issue?
I am developing an application in ASP.NET MVC, using SQL Server Express as the backend and Cassini as the development web server (the one that comes with Visual Studio 2008). The application performance is blazingly fast (nearly instantaneous page switches). However, spinning up the debugger is painfully slow; it takes about 30 seconds...
Which of these select statements is "better," and why?
Hi all, I have 2 table person and role. I have to all the persons based on role. select person.* from person inner join role on person.roleid = role.id Where role.id = @Roleid or select person.* from person inner join role on person.roleid = role.id AND role.id = @Roleid Which one of the above two solutions is better and Why? ...
Copy Data from a table in one Database to another separate database
Hello Basically I have a two databases on SQL Server 2005. I want to take the table data from one database and copy it to another database's table. I tried this: SELECT * INTO dbo.DB1.TempTable FROM dbo.DB2.TempTable This didn't work. I don't want to use a restore to avoid data loss... Any ideas? ...
How do I read a text file on the same server with ASP.NET?
Solution: It turns out I wasn't checking the path that it was looking up, quite silly of me. Once I tracked that problem down and corrected the offending path, the reading worked just fine. Still baffled at the MSSQL issue, since the articles average less than 10 000 bytes. Clarification: I am unsure if some of you are under the imp...
Concat groups in SQL Server
If I have a table like this: +------------+ | Id | Value | +------------+ | 1 | 'A' | |------------| | 1 | 'B' | |------------| | 2 | 'C' | +------------+ How can I get a resultset like this: +------------+ | Id | Value | +------------+ | 1 | 'AB' | |------------| | 2 | 'C' | +------------+ I know this is really easy ...