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...
I have a table which I created by importing a flat file (using SSIS). The table is set to all nvarchar datatypes at the moment. I would like to convert the columns of the table into specific...
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...
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...
Hello
I have a table with a lot of rows and every row has a timestamp:
machine1 / part1 / 01-01-2008
machine1 / part1 / 02-01-2008
machine1 / part1 / 03-01-2008
machine1 / part2 / 01-01...
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...
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...
