Viewing 15 posts - 26,026 through 26,040 (of 39,800 total)
We've had issues here with people using rules and missing newsletters, or duping them. I only use rules for moving things that I know I get to later, like newsletters.
I...
December 9, 2008 at 3:57 pm
update a
set leasenumber = c.
from machineaudit a
inner join machinename b
on a.computername = b.machinename
inner join leaseinfoimport c
...
December 9, 2008 at 3:15 pm
We'd like to see you do some of the work here. Why do you need to drop things in a temp table? If there are no records, then you can...
December 9, 2008 at 2:42 pm
You want the 5 rows prior to this line?
SELECT top 5 [pkid]
,[log_content]
FROM [Handheld_Logs].[dbo].[sample_log]
where [pkid] + 5 > ( SELECT [pkid]
...
December 9, 2008 at 2:41 pm
The default trace might help, but not sure if this is recorded.
A 1GB increase isn't much. If it is, you might have other issues. You should also always have...
December 9, 2008 at 2:39 pm
It's not the worst thing if you enable this, but it can be a security hole. If you know the CSV format, why not use a SSIS package? You can...
December 9, 2008 at 2:36 pm
Ahhh, I miss digging through code somedays 😉
December 9, 2008 at 2:27 pm
You might use a CASE in here for your logic.
If charindex() returns > 0, then there is a semi colon in there (if you are checking). Then you can use...
December 9, 2008 at 2:02 pm
Server (instance) properties or sp_configure under T-SQL, or use the Surface Area Config tool.
December 9, 2008 at 1:59 pm
Roy, when you say promote and merge into the mainline, you really mean two developers communicating, correct? Someone has to physically look at the patch that occurred, and then type...
December 9, 2008 at 7:56 am
First, stop using the CTP. It's not supported and RTM has been released. Move to that. Likely it's a VS2008 conflict somewhere, which is why I'd say move to...
December 9, 2008 at 7:54 am
Not sure what those are. Typically there are LocalSystem, LocalService, and NetworkService as the accounts.
I agree with Nicholas, I'd set up domain accounts, no rights, and let SQL use them...
December 9, 2008 at 7:52 am
I'd check on what Grant suggested.
Also, is this a data problem in any way or just differences in the way that the code is being interpreted?
December 9, 2008 at 7:50 am
SQL Server connections are through a port/IP combination, essentially a socket. If you have 3 servers all on default settings, and 1 public IP, you cannot connect through 1433 to...
December 9, 2008 at 7:47 am
Viewing 15 posts - 26,026 through 26,040 (of 39,800 total)