Hello, I have a database xyz and need to get all the table names, its column names and its length. - Which DMV should I use? - Is there a DMV...
Found out the following: In Restore Option: If the source database has AUTO_CLOSE off, after restoring to Express edition, the AUTO_CLOSE is still...
Hello, I have this .mdf file which is being generated by a different team. The database on their side has AUTO_CLOSE as OFF. But once I...
I finally figured out where to set the environment variable (Project -> properties ->Deploy ->Sql Command Variable file ->Edit ->Here gave Variable...
Thanks FrankKalis. Good to finally hear that there is a way to get this information. How do I identify this using SQLCMD? Thanks!
Another thing I can do is to get the current post deployment script directory (eg: E:\DBProj\Post_Deployment\ ) and use the same path for the flat...
use test go sp_configure 'xp_cmdshell', 1; GO RECONFIGURE; go EXEC master..xp_cmdshell 'bcp test.dbo.table1 in "Data_FlatFile.txt" -f...
I'm executing the bcp command from within xp_cmdshell. The reason why I'm using the xp_cmdshell command is because I want to include bcp command in...
Hello, I have a bcp command that loads data from a flat file into a table. Currently I'm using the following bcp command for it: bcp test.dbo.table1...
Thanks Luis!
Great! Thanks FrankKalis.
1. Just because the database tempdb has "ALLOW_SNAPSHOT_ISOLATION" as ON, does it mean that for the whole database the isolation level SNAPSHOT will...
The database I'm working on is in SQL SERVER 2008 and has SNAPSHOT isolation ON (See below). This was set by executing the following: ALTER...
I have this stored procedure that throws "Snapshot isolation transaction aborted due to update conflict". Which SQL Profiler event should I turn on...
Forgot to mention that I'm running SQL SERVER 2008 EXPRESS EDITION in Windows 7 operating system.
Hello, Question 1:I have this read only database against which I'm running couple of queries to record their response time. Inspite of data being...
Hello, I ran sql profiler with Template as "TSQL_Duration" for a stored procedure(A) which inturn calls couple of other stored procedures(B,C,D)...
Addition to the above questions: Below query to identify dirty pages, returns back with count as 5. select count(page_id) as 'dirty pages' from...
Thanks. Latest elapsed time: 1. Left my SSMS unused for 1/2 hour 2. DBCC FREEPROCCACHE CHECKPOINT DBCC DROPCLEANBUFFERS 3. Executed my query. It...
Not sure. How do I find that out? More Details: I'm running SQL SERVER 2008 EXPRESS EDITION in Windows 7 operating system. I see some vague results...
Separate names with a comma.
