copy and paste this google map to your website or blog!
Press copy button and paste into your blog or website.
(Please switch to 'HTML' mode when posting into your blog. Examples: WordPress Example, Blogger Example)
Input Form:Deal with this potential dealer,buyer,seller,supplier,manufacturer,exporter,importer
(Any information to deal,buy, sell, quote for products or service)
File extension . DB - What kind of database is it exactly? If you're on a Unix-like platform (Mac OS X, Linux, etc), you could try running file myfile db to see if that can figure out what type of file it is The file utility will inspect the beginning of the file, looking for any clues like magic numbers, headers, and so on to determine the type of the file
database - How to open this . DB file? - Stack Overflow I don't think there is a way to tell which program to use from just the db extension It could even be an encrypted database which can't be opened You can MS Access, or a sqlite manager Edit: Try to rename the file to txt and open it with a text editor The first couple of words in the file could tell you the DB Type
How do I grant read access for a user to a database in SQL Server? Once you have that user in your database, you can give it any rights you want, e g you could assign it the db_datareader database role to read all tables USE (your database); ALTER ROLE db_datareader ADD MEMBER (your user name);
How do I see active SQL Server connections? - Stack Overflow I threw this together so that you could do some querying on the results Declare @dbName varchar(150) set @dbName = '[YOURDATABASENAME]' --Total machine connections --SELECT COUNT(dbid) as TotalConnections FROM sys sysprocesses WHERE dbid > 0 --Available connections DECLARE @SPWHO1 TABLE (DBName VARCHAR(1000) NULL, NoOfAvailableConnections VARCHAR(1000) NULL, LoginName VARCHAR(1000) NULL
Create Local SQL Server database - Stack Overflow I've used SQL Server Management Studio before, but only when the server is already up and running I need to start from the beginning and create my own instance on the local computer
Copy tables from one database to another in SQL Server SQL Server Management Studio's "Import Data" task (right-click on the DB name, then tasks) will do most of this for you Run it from the database you want to copy the data into If the tables don't exist it will create them for you, but you'll probably have to recreate any indexes and such
How do I shrink my SQL Server Database? - Stack Overflow Shrink db (right-click db, choose all tasks > shrink db -> set to 10% free space) Verify that the space has been reclaimed, if not you might have to do a full backup; If that doesn't work (or you get a message saying "log file is full" when you try to switch recovery modes), try this: Backup; Kill all connections to the db
How to check which locks are held on a table - Stack Overflow USE yourdatabase; GO SELECT * FROM sys dm_tran_locks WHERE resource_database_id = DB_ID() AND resource_associated_entity_id = OBJECT_ID(N'dbo yourtablename'); See sys dm_tran_locks If multiple instances of the same request_owner_type exist, the request_owner_id column is used to distinguish each instance