Viewing 15 posts - 1 through 15 (of 58 total)
Try this script. You need to look at your duration figure as it appears to be more than a week. I also assumed that you use '10' to seperate the...
April 17, 2012 at 7:05 pm
Dynamic SQL should do the job given required columns exists in all tables with the same name. Even if the columns names are different in some tables, you may be...
April 16, 2012 at 8:37 am
November 24, 2011 at 7:16 am
Looks like either define @V2 as VARCHAR(MAX) or convert it to VARCHAR(MAX) in the concatination will give the correct results, but not NVARCHAR(MAX). Still don't know why though.
November 23, 2011 at 10:06 pm
Try this: Sheets("Sheet1").Copy Before:=Workbooks("Book2").Sheets(1)
It's really a VBScript question. You can google for the answer (too many there) or try record a macro in Excel and then see the code (that's...
June 23, 2011 at 8:02 am
Thank you for the reply, I greatly appreciate it. Your solution parses and executes but returns no date at all. any additional ideas?
Please check your statement can...
May 22, 2011 at 7:59 am
Thank you Lutz for the reply. As I also want to run it on SQL Server 2005 then what changes are required in this code.
CTE & ROW_NUMBER() were instroduced...
May 22, 2011 at 6:15 am
May 22, 2011 at 6:10 am
Can you re-produce the problem with adjusting memory setting to it's original values? If you can re-produce it, it may be related to memory setting (but I don't know why...
March 13, 2011 at 11:28 pm
Msg 50032, Sev 16, State 1: The process cannot access the file because it is being used by another process. LiteSpeed for SQL Server could not open the...
March 13, 2011 at 7:08 am
If I read it correctly, you are trying to replicate the 30 views for each schema for those users required. Any special reason for that? Can't you create the view...
March 1, 2011 at 10:30 pm
There is no black/white answer, "it depends". It depends more on your specific query and environment. please post your query and plan.
February 28, 2011 at 10:17 pm
Yes, restart service is the way to fix. Most interesting to me is that, I experieced this a few times on SQL2000 but not other versions above that (yet). I...
February 24, 2011 at 10:41 pm
Try this script that list the columns of a table in any index:
select column_name = c.name
from sys.index_columns ic
on ic.object_id = c.object_id and ic.column_id = c.column_id
where object_name(ic.object_id) = '<your...
February 24, 2011 at 5:39 am
One way might be set up a database role and grant "deny access" to those tables you want to hide from the user. Add those users as that role member.
February 24, 2011 at 5:28 am