-
How to find the list of system databases in a SQL Instance.
-
Can we partition a SQL Server table. If yes how to make patition in a SQL Server table.
Kiran Patil
- Mar 26th, 2008
Yes, there is table partitioning in SQL Server. Unfortunately I don't know how to do that, If anyone knows that, let me know.
-
Database Attach and Restore
What is the Difference between Attach and Restore of a Database?
Kiran Patil
- Mar 26th, 2008
Database attach is faster as compaired to Database Restore. SO if you have both options then may be you can choose Database attach than Database Restore.
nbkb9hv
- Feb 13th, 2008
Both are used to restore database, we Use attach database when we have .mdf file to upload data into database while we use restore database when we have .bak file to upload data into database.
-
Tail Log Backup
What is tail log backup? Where can we use it?
Kiran Patil
- Mar 26th, 2008
Tail Log Backup is the log backup taken after data coruption (Disaster). Though there is file corruption we can try to take log backup (Tail Log Backup). This will be used during point in time re...
-
How can I migrate database from ms SQL Server 2000 to SQL Server 2005? What are the steps?
bugeye
- Mar 15th, 2008
Take a full backup and restore or dettach 2000 db copy .mdf and ldf to 2005 server. Attach then switch compatiblity mode to 90 then update statistics. Once you go to 2005 you can go back.
-
Assign Deny Permissions to Specific User
How to deny insert, update, delete, update permissions for a specific user of a specific user database?
bugeye
- Mar 15th, 2008
So what context is the user in? A role a datareader? Datawriter?You want no permissions?USE <your db>Drop USER <your user> In a role?EXEC sp_droprolemember 'rolename&#...
-
I did not took backup for a database.My colleague had mad some changes to some Stored procedures and I want to roll back to the original codr.Since he did not used the begin transaction i am not able to rollback the changes.>How can I get back to my original code?
bugeye
- Mar 14th, 2008
Go to your last good full backup. Restore to another db using the MOVE command.
-
How many column maximum we can add in one table and how many foreign key maximum we can use in one table?
venkat.rbs
- Feb 12th, 2008
We can define up to 1024 columns. in one table....And 253 forignkeys we can assign for 1 table...
-
What is different between int and bint?
amitm79
- Feb 8th, 2008
Bigint can hold values from -2^63 (-9,223,372,036,854,775,807) to 2^63-1 (9,223,372,036,854,775,807) and it takes 8 bytesint can hold values from -2^31 (-2,147,483,648) to 2^31 - 1 (2,147,483,647) and it takes 4 bytes
-
Can we generate a trigger for two tables? if so what is the query to generate a trigger for two tables employee table and department table with employee having department no.
sreyas kvm
- Feb 3rd, 2008
Yes we can generate....CREATE TRIGGER Tgr2Tab ON dbo.employee FOR INSERT AS INSERT INTO dbo.department(SELECT departmentno FROM INSERTED )
chauhan_anilit
- Jan 10th, 2008
Usha G, your code is right but it only for first (SampleMainTable) table and execute whn you insert a record in the SampleMainTable tabe so its only for SampleMainTable table
-
Connection of SQL file to web page
How we can pulish the connectivity of SQL query to the HTML file or web page? Please Explain.
Mena1710
- Jan 30th, 2008
Normally connection of SQL file to a web page can be done in two ways1. Through the code2. In web config fileIf we give through the code, we need to alter the relevant pages, where as if we give throu...
-
Nested Trigger Levels
How many levels a trigger can be nested? Explain about nested triggers.
-
Optimisation and Performance
How optimisation and Performance in Sql Server 2000 can be achieved?What are the steps involved?
-
How many types of system privileges are there, Can we add or delete privileges?
sutanu_halder
- Dec 14th, 2007
There are over 80 distinct system privileges. Each system privilege allows a user to perform a particular database operation or class of database operations.Such as:- 1. ANALYZE ANY ...
-
Efficient way of Committing transactions
If I have 10 statements, individually committing each statement is efficient or doing a bulk commit of all the 10 statements at the end is efficient.Also if we say one of them is efficient... is it efficient in space or time or cpu?Thanks,rbala_sjsu
debasis.yours
- Dec 14th, 2007
There is a trade-off in this case. In case of transaction-oriented scenario, I think executing 10 statements separately would be a better option since it will hold the lock for a very short duration a...
-
Which one is better windows authentication mode or a SQL server authentication mode?
debasis.yours
- Dec 14th, 2007
Definitely Windows Authentication Mode. Firstly, the Windows security policy is used to authenticate is employed at user login reducing extra overhead. Secondly, if we implement any extra group policy...
-
SQL Server backup error
Error While creating BACKUP:I am Creating FullBackup for one database Named Postings.I executed below Query and i am getting The Below error message.USE mastergoEXEC SP_ADDUMPDEVICE 'disk','PostingsBac','E:BACKUPPostingsBac.BAK'BACKUP DATABASE Postings TO PostingsBacERROR:'Device Created'One Row Effected.Server: Msg 3201, Level 16, State 1, Line 1Cannot open backup device 'PostingsBac'. Device error...
debasis.yours
- Dec 14th, 2007
This is basically a problem with the physical path of the Backup device, I suppose. Be sure the physical path that you are giving has full access from your Windows user Account or not.
-
How logical architecture of DBMS differs from physical architecture
vijaya_pitta
- Dec 12th, 2007
Architecture is the frame work of the Database Management System. They are simply classified into logical and physical.
-
What is XMLA in SQL Server 2005
I would like to know whether it uses SOAP or XML.
opbang
- Dec 9th, 2007
XML for Analysis (XMLA) is a Simple Object Access Protocol (SOAP)-based XML protocol, designed specifically for universal data access to any standard multidimensional data source residing on the Web. ...
-
SQL Server data in XML Format
How to display the table data in XML format using SQL Server.
SQL Server Interview Questions
Ans