SQL Activity manager- I have a process that is running 2 transaction and is being blocked by another process at awaiting command, i have a trigger running and i beleive it may be whats causing...
Do I have to stop SQlserver/sqlserver agent services before changing the password??
I have a datbase where the T-log is 10GB. The drive is only 13GB, so it's filling it up.
I have set Enterprise Manger to execute to shink the T-log to 1GB, the file data contains 550MB of d...
I am writing a report for the local sheriffs office here and I am trying to find a way to show evidence items that have been returned from FDLE agencies. Here is what a sample set of the tabl...
I have HTML text in a field. I need to get it into a file on my server.
I am using the attached SQL code in a SPROC and need help getting it running. By now I have completely screwed it u...
I am trying to write a program to iterate through data in a SQL server table to us in a http request. I found the following code to use:
'replace the database information <source>, <catalog...
In the attached query I specify that if the "DueDate" falls on a weekend THEN DueDate + 1 OR + 2...
I need to ALSO make sure that Weekends are not counted when Adding Dates:
Consider the...
Hi all !
I have a table that is updates ever 5 - 10 mins by my application to show connected users. I plan on creating a service to drop old connections to monitor the application. The tabl...
I have emp table with one column called salary. Is there a way to make the following working? Thanks.
select salary*0.3 commision, commision -1 real_commission, real_commission + salary to...
How can I concat string in dynamic sql?
I need to put the below SQL in Dynamic sql
Select ID ,Question, answer, (question + ':' + answer) as Question_Text from table
where question = @qu...
Can anyone recommend some good resources/tutorials or utilities for Microsoft SQL Server in regards to generating and XML export?
I'm trying to change ownership of a single table from dbo to one of the managers. I have complete sa rights. The solution that I saw earlier wouldn't work. Please Help.
The ASPNET team chose to use GUIDS as identifiers in the ASPNETDB schema. Can anyone tell me why? All of the other information I can find seems to indicate that they would have been better off...
I have set up a mirrored database, with no witness, on high performance. I am not sure, if the principal db fails, how to failover manually?
I have a cfunction that calls a store procedure in SQL 2000. I need to have the parameter #url.order# in the ORDER BY of the store procedure. The #url.order# parameter needs to run as the ORDE...
I have a SQL table with 3 columns as shown below:
Status date | Status Code| AccountNumber
__________|__________|______________
02-01-2008 1 a1024
01-01-2007 ...
I need to report sales values collected from line items in sales orders, and I need to report these figures using a hierarchy of product categories, where the value for each category includes ...
Hello,
I have several tables in which I need to order the data in an absolute way, but neither the key nor the data are suited to be sorted by. Example would be a table for 'conditions' th...
I have the below query and I'm trying to get the results from Oracle database using
linked server in Sqlserver. I'm trying to use the to_date function to get the YYMMDD
format but I'm gettin...
All,
Please review the following links for supporting information
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23436895.html
http://www.experts-exchange.com/Micro...
Hi,
I have reinstall my db but without restore master db, and I have also restore the user db, now the prob is this db have few user which should be have access as sql login too, I try to cre...
How can I avoid the "login to database" prompt when staring Sql Server Mgt. Studio.
thanks,
bmutch
Hello Experts
I have a table that has data like this:
ctrlnum src refnum descr. date amount
42472 5 010207DC...
Hi, I have a table of key words (that change) that can appear in an address field to indicate whether the customer has an address that is only accessible by boat (probably a cottage). I would...
Let's say I have the following table of baseball players:
name team pos_type hits
---------------------------------------------------------------------------------------------
utley phl...
