Viewing 15 posts - 31 through 45 (of 45 total)
try this , u can change it and use sp_msForEachDB to loop around all databases
SELECT sc.name +'.'+ ta.name TableName
FROM sys.tables ta
INNER JOIN sys.partitions pa
January 16, 2014 at 12:58 am
check out this link
January 16, 2014 at 12:41 am
Use Top (250,000) in your report query, have a count of records and expression to display text showing maximum records reached
January 10, 2014 at 2:03 am
Have a look at Windows Event Viewer, you will have a pretty good Idea what is causing the error
November 20, 2013 at 12:41 am
you should never backup tlogs of databases in simple recovery mode.
if you are using a T-sql script to do the backup , I suggest you exclude db's with simple recovery...
October 9, 2013 at 7:10 am
Use TRY and CATCH
-- Table does not exist; object name resolution
-- error not caught.
SELECT * FROM...
October 9, 2013 at 2:02 am
The APPLY operator allows you to join two table expressions; the right table expression is processed every time for each row from the left table expression. the left table expression...
October 9, 2013 at 1:28 am
SQL Server will not kill or drop any connection/process unless the service is initiated for a restart or referred from the client process
A sleeping session is waiting for its next...
September 26, 2013 at 3:36 am
check the summary.txt file on directory C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log
it will give you more details about the errors.
September 26, 2013 at 3:18 am
This issue is occurring because you are having a 64 bit OS and Office Excel (including most of the office products) does not have 64bit provider and hence the error...
September 26, 2013 at 3:02 am
Try something like this
WHERE CONTAINS(MyColumnName, '"*How*" OR "*to*" OR "*migrate*" OR "*reports*" OR "*between*" OR "*different*" OR "*versions*"');
September 26, 2013 at 2:56 am
DECLARE @t TABLE(city VARCHAR(1))
INSERT INTO @t(city)
VALUES ('A'),( 'B'),( 'C'),( 'A'),( 'B'),( 'C'),( 'A');
-- do a select and not the results for comparison purposes
SELECT city FROM @t
SET city =...
September 25, 2013 at 3:52 am
create a temp table and openrowset your stored procedure data into it
INSERT INTO #tmp_table
OPENROWSET ('SQLOLEDB','Server=(local);TRUSTED_CONNECTION=YES;','set fmtonly off EXEC [ServerName].dbo.[StoredProcedureName] 1,2,3')
September 25, 2013 at 2:50 am
ChrisM@Work Sergily , 🙂 Thank you guys very much, I used both your suggestions and got Desired results 😉
August 10, 2012 at 2:48 am
this is the Tsql i was using
SELECT [Column 1], [Datatime],[Column 2] , [Column 3]
FROM [test].[dbo].[upload] S
WHERE NOT EXISTS (SELECT *
FROM [test].[dbo].[upload] ...
July 5, 2012 at 4:28 am