• SQL Server 2008: Shrink database files

    In SQL Server 2008, is there a way I can shrink my files (log and data) on all of my databases? I've already tried to use SSMS and right click each one but that's way too slow. Is there anything faster?

    ITKE409,350 pointsBadges:
  • Re-add user to SQL Express 2012 database

    About once every six months, I move our database (SQL Express 2012) from our development machine to our server. Usually, I use SSMS for backup and restore. But the apps on the target machine can't access the database until I get rid of the user they use and re-add it. Does anyone know if there's a...

    ITKE409,350 pointsBadges:
  • How to install SQL Server Management Studio locally on my desktop

    Does anyone know if I can install SQL Server Management Studio locally (meaning - on my desktop) so I could access my database on a SQL Server instance? I've seen the express version but I need something else.  Thanks!

    ITKE409,350 pointsBadges:
  • SQL Server 2012 – Profile stored procedures

    I'm currently using SQL Server 2012 and I'm trying to figure out if I can profile stored procedures. I need to capture each SQL Statement in my stored procedures (basically how long it takes to run). Thanks so much.

    ITKE409,350 pointsBadges:
  • SQL Server 2008: Assign Active Directory group security access

    On my domain, I need to have integrated security with my internal app. I've tried several times but it's never really worked out for me. Can I assign an Exchange / Active Directory group a role in SQL Server to have read/write access in specific tables? Just so everyone knows - this is for SQL...

    ITKE409,350 pointsBadges:
  • SQL Server: Get database name

    How do I get the database name and associated user mapped for all database in SQL Server?

    testsdf5 pointsBadges:
  • How to tell if my SQL Server database is still in use

    We have to get rid of a SQL Server instance (basically decommission it) but it still has several databases left on it. Is there a way to tell if these databases are still being used by our users? Thank you very much.

    ITKE409,350 pointsBadges:
  • Calculating moving average cost rate in SQL Server

    I am trying to calculate a moving average rate for stock valuation and profit margin calculation, we have following table: ProductID PurchaseQty PurchaseRate SaleQty SaleRate CostRate(Auto Calculate) ========================================================================= 1 4 500 0 0 500 =(2000/4)...

    mkfaiz5 pointsBadges:
  • How to use SQL Server 2005

    I have installed SQL Server 2005 but I want to know how to open SQL Server and connect the DB.

    Anand79865 pointsBadges:
  • SQL Server 2008: Counts within a date range

    I need to be able to count an id and the ids duplicates when the createdate is >= 3 months or 90 days (whatever is easier) for the ids createdate. I'm using temp tables and any help would be appreciated as I'm farily new to SQL id CreateDate Counts_id 1 01/01/2015 2 1 04/01/2015 2 2 01/01/2015 1...

    jrming015 pointsBadges:
  • Hanging session in SQL Server

    A session is in KILL/ROLLBACK state for some time. I do not want the database to become inconsistent and would like some help on the steps on how to solve this. kill 85 with statusonly; SPID 85: transaction rollback in progress. Estimated rollback completion: 0%. Estimated time remaining: 0...

    Mia123455 pointsBadges:
  • Recover records on SQL Server 2008 table

    In my remote SQL Server 2008 table, I accidentally deleted over a million records. Now, the server won't let me back in and access to the backup files on the server side. How can I get some of these records back?

    ITKE409,350 pointsBadges:
  • Copy SQL stored procedure from local to live database

    Hello, I want to copy multiple procedures from a local database to a live database?

    vikasbhatt25 pointsBadges:
  • How do insert many images (BLOB) into a SQL Server table

    How do I insert several images (BLOB) in to a SQL Server table?

    cjohnNewVIc5 pointsBadges:
  • Open IT Forum: Tell us your must-read IT blog or Twitter feed & earn 50 knowledge points!

    We're always looking for great resources to share with the community, so here's your chance to share what's in your own bag of tricks! Share your favorite IT blogs or Twitter personalities, what they write about, or a link to a post that taught you something you'll never forget. Don't have a...

    MelanieYarbrough6,345 pointsBadges:
  • SSRS line chart color

    I have PV and high two series on one chart. I need to compare PV vlaue with high, when PV value is deviated to high then set the color red. I wrote the expression as "IFF(PV<=HIGH, RED, GREEN", for which I got the color but there is a small problem. For example: PV = 20, 25, 28, 35, 37, 39, 28....

    anu4kumari5 pointsBadges:
  • Migrate data from MySQL to SQL Server

    Hi all SQL Server experts, I'm new to SQL Server. Can you please help me out from I want to migrate data from MySQL to MS SQL. What steps do I need to follow? Can you please tell me in step-by-step? Thanks in advance.

    nasarbabu30 pointsBadges:
  • Execute SQL SELECT via RUNSQLSTM error

    Trying to execute SQL-statement "SELECT * FROM mylib/myfile" give errormsg SQL9010. Some say that SELECT is not supported with RUNSQLSTM, but IBM command parameter text indicates otherwise. Is SELECT supported and what am I doing wrong?

    DanTheDane2,555 pointsBadges:
  • SQL injection attack detection

    How can I find if my site is vulnerable for SQL injection attacks? Can anyone share the tips to prevent it?

    KelvinS80 pointsBadges:
  • MS SQL Server version

    Hi MS-SQL Server-ers, I'm wondering with is the date displayed in the version of SQL Server (by using @@version)? Could anyone tell me what is that date referred to? Thank you!

    srithea330 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following