Viewing 15 posts - 481 through 495 (of 498 total)
I would go with Replication. Having written a home brew replication engine I can tell you that you don't want to do it! Your needs are exactly what replication is...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 18, 2002 at 3:36 pm
Evan,
I would suggest you read up on Aliasing in SQL Books Online. Basically what we have done in my query was to alias the table name so that we didn't...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 17, 2002 at 2:11 pm
You might want to put a wrapper on SQL's stored procedures that Profiler uses. You can find them in BOL for System Procedures...
sp_trace_create
sp_trace_setfilter
sp_trace_generateevent
sp_trace_setstatus
sp_trace_setevent
Gary Johnson
DBA
Sr. DB Engineer
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 17, 2002 at 2:06 pm
DOH!
Try changing the T to U... Helps if I don't try to do three things at once!
Gary Johnson
DBA
Sr. DB Engineer
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 17, 2002 at 1:55 pm
Try
SELECT T.UserID, T.Name, UserCount = COUNT(T.UserID)
FROM TUserLogs U
JOIN TSubscribers S ON U.UserID = S.UserID
GROUP BY T.UserID, T.Name
ORDER BY COUNT(T.UserID) DESC
Gary Johnson
DBA
Sr. DB Engineer
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 17, 2002 at 1:49 pm
I agree, it looks like a permissions issue. If you look at
The job failed. Unable to determine if the owner (GLOBAL\TPNSQLServer) of job Expired subscription clean up has server...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 16, 2002 at 12:01 pm
I found this in help...
The ListAvailableSQLServers method is supported only for servers and workstations running Microsoft Windows NT® 4.0 and Microsoft Windows 2000.
However even running it on 2000 with SQL...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 16, 2002 at 11:39 am
While I have done the while loop on the identity column as I stated before, I never use Select Into. I always manually create the table or declare the table...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 16, 2002 at 10:32 am
As Don stated this is not a good use of an identity column.
The way I have done this in the past is to create a temp table and put...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 13, 2002 at 2:13 pm
If your query is only going to return 1 record then you can simply select the field value into a variable as follows:
DECLARE @bFoo bit
SELECT @bFoo = Foo
FROM TBL
WHERE ID...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 13, 2002 at 1:49 pm
The best thing about using the function is that you can simply replace the original table with the function in your select statement. Also you could add parameters for the...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 13, 2002 at 12:09 pm
I've done something very similar to what Jeff just posted. Only main difference was we wrapped it in a transaction.
BTW: Be VERY careful of using identity columns if you ever...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 13, 2002 at 12:04 pm
If you are using the debugger and have the check box to rollbak at the end checked then the following will not create a new transaction as @@TRANCOUNT will be...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 13, 2002 at 10:14 am
At times cursors are the best way to do things. You might also think about using a table variable that has an identity column and then doing a while loop...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
December 13, 2002 at 9:59 am
quote:
Thanks.Steve, details about the 'issues' would interest me. Sorry if you mentionned them elsewhere and I didn't see them.
Elno
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
December 12, 2002 at 6:06 pm
Viewing 15 posts - 481 through 495 (of 498 total)