Viewing 15 posts - 3,556 through 3,570 (of 9,643 total)
You would test for the existence of the table before creating the table. Like this:
IF OBJECT_ID('Empdata') IS NULL
BEGIN
...
December 17, 2009 at 9:35 am
Great article Jonathan. Makes everything clear. Signing a module is very useful in many areas.
December 17, 2009 at 8:42 am
You'd have to query AD to find out. You can do it using a Linked Server or you could try your hand at PowerShell.
December 17, 2009 at 8:40 am
Lynn Pettis (12/17/2009)
I am having trouble thinking straight on this one, could someone else jump in here and help. It isn't collation, it is the dateformat.
I jumped in on...
December 17, 2009 at 8:32 am
Run the dates in the reports through custom code that converts to a universal time format which would be yyyymmdd hh(24):mm:ss. Jamie Thompson had a good T-SQL Tuesday blog...
December 17, 2009 at 8:30 am
Don't know why that is. Try checking out this article at MSSQLTips.
December 17, 2009 at 8:11 am
There isn't one that I am aware of. Basically it is not an issue. Odds are that any tables that small are likely in the buffer cache so...
December 16, 2009 at 9:13 am
I don't have 2000 to run this against, but something like this should work:
CREATE TABLE #logins
(
sid VARBINARY(MAX),
...
December 16, 2009 at 8:45 am
I don't think you can reference a value from a subreport in a main report.
December 16, 2009 at 8:28 am
Can you post the table definitions and some test data as outlined in the first article linked in my signature?
December 16, 2009 at 8:27 am
I forgot to mention you could also use a server-side trace or query the default trace for the Audit Add Login to Server Role Event. The only problem with...
December 16, 2009 at 8:04 am
A DDL trigger at the server scope could do this. I think you'd want to look at these events:
ADD_SERVER_ROLE_MEMBER - you'd want this one so you can see if...
December 16, 2009 at 7:51 am
Sometimes you get better performance by doing the aggregating in a CTE or a derived table. Something like:
SELECT
S.Name AS StateName,
C.sName...
December 16, 2009 at 7:35 am
Is the SQL Server service running?
December 16, 2009 at 7:08 am
I agree with Gail also will mention that the INFORMATION_SCHEMA.TABLES view is database specific so unless you run that query in tempdb you won't find your temporary table any way....
December 15, 2009 at 7:58 am
Viewing 15 posts - 3,556 through 3,570 (of 9,643 total)