• Copying SQL Azure database to development machine

    I'm looking to copy my SQL Azure database to my local development machine. I already have a development database in the cloud but don't want to pay for it anymore. I have copied by production database to the new development database but I need that same one on the local machine. How can I go about...

    ITKE440,475 pointsBadges:
  • Oracle 10g CONTINUE keyword for T-SQL stored procedure migration

    I'm looking to migrate a T-SQL stored procedure to PL/SQL but I'm constantly running into one particular issue. I noticed that there isn't a CONTINUE keyword for Oracle 10g. Is there a workaround for this? My friend told me to just upgrade but I can't do that right now.

    ITKE440,475 pointsBadges:
  • Three ways to login in to SQL database server?

    Does anyone know what are the three ways to login in to SQL database server?

    melbourne5 pointsBadges:
  • How to take a table-level backup in SQL Server 2008

    Does anyone know how to take a table-level backup in SQL Server 2008? Can we use the backup database command? Thank you!

    ITKE440,475 pointsBadges:
  • Deleted SQL Server 2005 database

    Hi, actually I know the importance of backup, but I don't have the back up in any-how condition. Accidentally the database deleted by me. How do I recover it? How to use the transaction.log file to restore deleted database in SQL Server 2005?

    Lalit35 pointsBadges:
  • Changing password on SQL Express 2008

    I recently installed SQL Server Express 2008 and I'm signing in using Windows authentication. But after that, I can't do anything. Is there a way I can change the password so I can have access? I'm also using Windows 7.

    ITKE440,475 pointsBadges:
  • How can I change SQL language and date format?

    I'm using an older version of SQL Server (2005 to be exact). So when I try to execute, DBCC USEROPTIONS, it's giving me a foreign language and the date format DMY. I need the language to be in English / format in MDY. Is there a way to change this? Thank you very much

    ITKE440,475 pointsBadges:
  • Can I restore my SQL Server 2012 database backup to SQL Server 2008?

    This probably isn't possible but can I restore my SQL Server 2012 database backup to SQL Server 2008? I'm assuming I can only go forward, not backup.

    ITKE440,475 pointsBadges:
  • Free online practice exercises on SQL/Oracle

    I would like to know is there any website which offers free practice exercises on SQL/Oracle queries? Preferably advanced level queries. Thanks, Kruti

    Kpatel0 pointsBadges:
  • Opening SQL Server ports

    I'm looking to open up my SQL Server port through a Windows firewall but I'm struggling with the process. Is there a way I can find the ports that SQL is running on so I can open them?

    ITKE440,475 pointsBadges:
  • Should I run a SQL view in my SQL Server database?

    For SQL Server, should I run a SQL view in my database? My friend told me to just run a stored procedure but I would rather run a view for security purposes. What should I do?

    ITKE440,475 pointsBadges:
  • SQL command for database recovery

    Does anyone know if there's any SQL command that can determine the recovery model of my SQL Server database? I'm trying to figure out if the database is in full recovery. Thank you very much.

    ITKE440,475 pointsBadges:
  • Using Count in SQL database

    I have a database with students results, for test and assignments also examination final marks so I want to count the number of student who wrote a certain test, count the number of those who passed and those who failed. How can I implement that in SQL?

    EllyodM5 pointsBadges:
  • Network documentation/Diagram

    I am curious as to how others are documenting their network; both visually and configurations. I am familiar with MS Visio for drawing the network. Are there better options? What about documenting all equiptment? IP addresses? Settings? Changes? I am just using MS Excel/word to create all sorts of...

    Skepticals0 pointsBadges:
  • Network Connection Freezes

    For some reason, at random, among 20 PCs on my network, in the morning or during the day, the network connection stops responding for both intranet and internet communications. The only solution thus far is to remove the NIC from the Device Manager, reboot the PC, and let Windows XP Pro find the...

    DboiSOBE0 pointsBadges:
  • Permissions for SSRS database reports

    For SSRS, is there a way I can find out what logins/users have access to specific reports? I'm looking to create a datamart so I can create reports for different managers who want to see who has access to these reports. Thanks!

    ITKE440,475 pointsBadges:
  • Getting error on TempDB – how to resolve?

    The database consistency IO error on "path\tempdb.mdf" every day this error are getting we run the DBCC checkdb (TempDB) but no error why this error getting triggered.

    edwinjhoffer3,365 pointsBadges:
  • Restricting SQL Server database access

    We currently have a SQL Server that has roughly 50 databases. I need to create a login for one of our clients who needs access to one of the databases. Here's the catch: I don't want to give them access to any other database. Is there a way I can do this?

    ITKE440,475 pointsBadges:
  • Step-by-step procedure creation of SQL Server 2012

    How can I create a version of SQL Server 2012 for myself? I need the step-by-step process.

    nkvasani5 pointsBadges:
  • SQL Server permissions

    Is there a report that shows which user has which roles? Also, Is there a report that shows what roles have which privileges?

    buckeyedba5 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.