• 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!

    ITKE827,935 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?

    ITKE827,935 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:
  • Search text in SQL Server stored procedure

    For SQL Server, I'm trying to search a text from all of my database stored procedures. Here's the code I'm using: SELECT DISTINCT o.name AS Object_Name, o.type_desc FROM sys.sql_modules m INNER JOIN sys.objects o ON m.object_id = o.object_id WHERE m.definition Like '%[ABD]%'; But I'm not getting...

    ITKE827,935 pointsBadges:
  • Backup error when restoring SQL Server database

    A few days ago, I backed up my database that I created on another machine (which was running SQL Server 2012 Express) and I need to restore it on my machine. However, I keep getting this error when I'm trying to do it: Backup mediaset is not complete. Files: D:\question.bak. Family count:2. Missing...

    ITKE827,935 pointsBadges:
  • How can I force a replacement for backup database?

    For my SQL Server database, I'm trying to back it up using my code here: sqlcmd -S servername -Q "BACKUP DATABASE [DBName] TO DISK = 'C:\backup.bak'" I mean, it's working fine but if my backup file exists, my data gets appended to the file instead of replacing it. When I try to call BACKUP DATBASE,...

    ITKE827,935 pointsBadges:
  • SQL Server error message: Access is denied

    For SQL Server, I have a database on my machine and then created a backup of my tables. I just moved my backup to a remote machine without the table. But when I tried to restore it, I keep getting this error: System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is...

    ITKE827,935 pointsBadges:
  • Error message when restoring .BAK file on SQL Server

    I've been trying to restore a .BAK file on SQL Server for the past few days but I keep getting this error message: Msg 3241, Level 16, State 7, Line 1 The media family on device 'c:\glyn\JA.bak' is incorrectly formed. SQL Server cannot process this media family. I've tried several queries on 2008...

    ITKE827,935 pointsBadges:
  • SQL Server 2000 backup failed

    can not backup a 2000 db, dbcc checkdb ok. see following: Errorlog: 2008-01-08 09:54:40.69 spid62 Starting up database 'CP2005'. 2008-01-08 09:54:41.00 backup BACKUP failed to complete the command BACKUP DATABASE [education] TO DISK = N'C:\fjs1\education_db_200801080954.BAK' WITH INIT , NOUNLOAD ,...

    Fjsittler5 pointsBadges:
  • SQL Database is corrupted

    Respected sir, Unfortunately the hard disk of my system is damaged, now I recovered my database. but it cannot be attached again to SQL management studio 2005. The error is myfile.mdf is not a primary database file. (SQL server, error 5171) Please sir help me.

    shampur5 pointsBadges:
  • Export / import data from Excel to SQL database

    Hi, I want to do one program in which I have one Excel sheet that some data can be stored. I want to import that data in VB.NET application and store it in a SQL database and do same thing vice versa. Which means I can fetch data from SQL database through VB.NET and store that data in Excel. Please...

    qwertyudicdi10 pointsBadges:
  • Tracing with SQL Server profiler

    I'm using SQL Server and I've just started to use the profiler function. Is there a way I can trace using SQL Server profiler? Do I have to use SSMS? Thank you!

    ITKE827,935 pointsBadges:
  • Transfer data from Oracle Hyperion to SQL Server

    Can I transfer all my data (tables, columns, etc.) from Oracle Hyperion to SQL Server? Would SSIS work for this? Thank you!

    ITKE827,935 pointsBadges:
  • Select reserved words in Oracle

    How can I select reserved words in Oracle. For example: In T-SQL, I'm able to select a column that's called table by using Select [table] from tablename. But I can't figure out how to do it with Oracle. Thank you very much.

    ITKE827,935 pointsBadges:
  • T-SQL: Split numbers into a table

    For T-SQL, I have to split 1,2,3,4,5,6,7,8,9,10 9 into a table (also comma delimited). How can I do that? Is there some sort of function that I can return each one in a row? Thank you so much.

    ITKE827,935 pointsBadges:
  • A01 Extension File

    Hi, It is some kind of DB file which has extension .a01. But I can't read the file because it's not clear. When I open it in notepad, it displays ASCII (Encrypted Format) only.

    Rupees15 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